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" <[email protected]>
An [email protected]
Datum 20.03.2023 10:53:27
Betreff Re: Azure SQL Problems

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...

On Mon, Mar 20, 2023 at 10:16 AM Simon Martinelli <[email protected]> wrote:
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
On Monday, March 20, 2023 at 8:26:09 AM UTC+1 [email protected] wrote:
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


On Sun, Mar 19, 2023 at 11:29 AM Simon Martinelli <[email protected]> wrote:
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

--
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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/4d27f01f-1a96-4b74-bffd-ffcbc3b7de81n%40googlegroups.com <https://groups.google.com/d/msgid/jooq-user/4d27f01f-1a96-4b74-bffd-ffcbc3b7de81n%40googlegroups.com?utm_medium=email&utm_source=footer>.

--
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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/78fad680-5e79-49b0-b077-f06b399e514cn%40googlegroups.com <https://groups.google.com/d/msgid/jooq-user/78fad680-5e79-49b0-b077-f06b399e514cn%40googlegroups.com?utm_medium=email&utm_source=footer>.

--
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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO4YkQdcWKo2bPZhvc4XYuyNVQMpfP%3Dp4BGAtDb0JWRcVw%40mail.gmail.com <https://groups.google.com/d/msgid/jooq-user/CAB4ELO4YkQdcWKo2bPZhvc4XYuyNVQMpfP%3Dp4BGAtDb0JWRcVw%40mail.gmail.com?utm_medium=email&utm_source=footer>.

--
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 [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jooq-user/eme648ae77-7f38-45ec-9ee5-9c89bc211105%404dd600a8.com.

Reply via email to