Azure SQL Problems

[Simon Martinelli]

Hi,

I use Azure SQL and when starting the Spring Boot App I see:

Version mismatch         : Database version is older than what dialect SQLSERVER supports: 12.00.937. Consider https://www.jooq.org/download/support-matrix to see what jOOQ version and edition supports which RDBMS versions.

My configuration is:

@Configuration
public class ContestJooqConfiguration {

@Bean
Settings jooqSettings() {
return new Settings()
.withParseDialect(SQLDialect.SQLSERVER2014)
.withInterpreterDialect(SQLDialect.SQLSERVER2014)
.withRenderCatalog(false)
.withRenderSchema(false);
}
}

Also, the configuration withRenderCatalog and Schema is ignored!

select [contest].[mar].[c_sport_branch].[id]

What's wrong with my configuration?

Thanks, Simon

[Lukas Eder]

Hi Simon,

The log message is based only on the SQLDialect, not the parse dialect or interpreter dialect. Did you set that to SQLSERVER2014 as well?

The ignoring of the render catalog / schema setting is probably a bug? Can you report it here with more details on how to reproduce it?

https://github.com/jOOQ/jOOQ/issues/new/choose

Thanks,

Lukas

--
You received this message because you are subscribed to the Google Groups "jOOQ User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/4d27f01f-1a96-4b74-bffd-ffcbc3b7de81n%40googlegroups.com.

[Simon Martinelli]

Hi Lukas,

The problem was solved. I had to set the configuration a bit differently.

@Configuration
public class Contest20JooqConfiguration {

@Bean
public DefaultConfigurationCustomizer configurationCustomizer() {
return (DefaultConfiguration c) -> c.settings()
.withRenderCatalog(false)
.withRenderSchema(false);
}
}

Setting the dialect helped as well

Thank you

Simon

[Lukas Eder]

Hi Simon,

That's interesting, I've seen this a few times now. Seems to be some sort of Spring Boot 3.0 "regression"? Have you considered reporting this to https://github.com/spring-projects/spring-boot ? While the customizer is certainly more explicit, I'm wondering if the previous approach should really no longer work. I don't see any obvious reason for it not to work, though I might be missing something from Spring Boot 3.0...

To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/78fad680-5e79-49b0-b077-f06b399e514cn%40googlegroups.com.

[Simon Martinelli]

Indeed!

I have an app with Spring Boot 2.7 and there the same configuration works.

Must be some Spring Boot 3 issue. I'll investigate a bit more and will report and issue.

Thanks, Simon

------ Originalnachricht ------

Von "Lukas Eder" <lukas...@gmail.com>

An jooq...@googlegroups.com

Datum 20.03.2023 10:53:27

Betreff Re: Azure SQL Problems

To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO4YkQdcWKo2bPZhvc4XYuyNVQMpfP%3Dp4BGAtDb0JWRcVw%40mail.gmail.com.