JOOQ Trial

132 views
Skip to first unread message

Nicola Micheli

unread,
Jul 25, 2019, 7:21:46 AM7/25/19
to jOOQ User Group
I use JOOQ Trial for generation and it work fine.

But when start application I receive this error:

Failed to bind properties under 'spring.jooq.sql-dialect' to org.jooq.SQLDialect:

    Property: spring.jooq.sql-dialect
    Value: ORACLE
    Origin: class path resource [application-tn.yaml]:16:18
    Reason: failed to convert java.lang.String to org.jooq.SQLDialect

Action:

Update your application's configuration. The following values are valid:

    CUBRID
    DEFAULT
    DERBY
    FIREBIRD
    FIREBIRD_2_5
    FIREBIRD_3_0
    H2
    HSQLDB
    MARIADB
    MYSQL
    MYSQL_5_7
    MYSQL_8_0
    POSTGRES
    POSTGRES_10
    POSTGRES_9_3
    POSTGRES_9_4
    POSTGRES_9_5
    SQL99
    SQLITE

Lukas Eder

unread,
Jul 25, 2019, 8:37:47 AM7/25/19
to jOOQ User Group
Thank you very much for your message.

Spring Boot depends on the jOOQ Open Source Edition by default (Maven groupId "org.jooq"). In order to use a commercial distribution, you have to exclude Spring Boot's jOOQ dependency from yours, and add the commercial distribution (Maven groupId "org.jooq.trial" in this case) explicitly to your classpath. If you're using Maven, then here's a handy blog post that explains how to do that:

Please let me know if I can be of any further assistance, and I'll be very happy to help.

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/6e973622-b742-4b85-bad7-904a3e1f2eef%40googlegroups.com.

Nicola Micheli

unread,
Jul 25, 2019, 10:38:34 AM7/25/19
to jOOQ User Group
I solve one problem but I have problem with jooqRuntime this gradle file 
 dependencies {
        ...
        ...
        classpath "org.springframework.boot:spring-boot-gradle-plugin:${springBootVersion}"
        classpath "nu.studer:gradle-jooq-plugin:${jooqPlugin}"
        ....
        ....

      }

and nu.studer:gradle-jooq-plugin import org.jooq:jooq:3.11.2 how I force to use org.jooq.trial:jooq?




Il giorno giovedì 25 luglio 2019 14:37:47 UTC+2, Lukas Eder ha scritto:
Thank you very much for your message.

Spring Boot depends on the jOOQ Open Source Edition by default (Maven groupId "org.jooq"). In order to use a commercial distribution, you have to exclude Spring Boot's jOOQ dependency from yours, and add the commercial distribution (Maven groupId "org.jooq.trial" in this case) explicitly to your classpath. If you're using Maven, then here's a handy blog post that explains how to do that:

Please let me know if I can be of any further assistance, and I'll be very happy to help.

Thanks,
Lukas 

To unsubscribe from this group and stop receiving emails from it, send an email to jooq...@googlegroups.com.

Nicola Micheli

unread,
Jul 25, 2019, 10:40:19 AM7/25/19
to jOOQ User Group
I solve one problem but I have problem with jooqRuntime this gradle file 
 dependencies {
        ...
        ...
        classpath "org.springframework.boot:spring-boot-gradle-plugin:${springBootVersion}"
        classpath "nu.studer:gradle-jooq-plugin:${jooqPlugin}"
        ....
        ....

      }

and nu.studer:gradle-jooq-plugin import org.jooq:jooq:3.11.2 how I force to use org.jooq.trial:jooq?

Il giorno giovedì 25 luglio 2019 14:37:47 UTC+2, Lukas Eder ha scritto:
Thank you very much for your message.

Spring Boot depends on the jOOQ Open Source Edition by default (Maven groupId "org.jooq"). In order to use a commercial distribution, you have to exclude Spring Boot's jOOQ dependency from yours, and add the commercial distribution (Maven groupId "org.jooq.trial" in this case) explicitly to your classpath. If you're using Maven, then here's a handy blog post that explains how to do that:

Please let me know if I can be of any further assistance, and I'll be very happy to help.

Thanks,
Lukas 

To unsubscribe from this group and stop receiving emails from it, send an email to jooq...@googlegroups.com.

Lukas Eder

unread,
Jul 25, 2019, 11:01:56 AM7/25/19
to jOOQ User Group
Hi Nicola,

Thank you for your follow up question. Would it be possible to show a complete example of what you've tried? It would certainly help reproducing the problem, given that you're now using 2 third party components that have various ways of interacting badly with each other.From your email, I'm not sure what could be the reason that you're getting the wrong artifact on your classpath.

Thanks,
Lukas

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/a831fa44-667d-4737-82e9-79b90870e306%40googlegroups.com.

Nicola Micheli

unread,
Jul 26, 2019, 10:09:31 AM7/26/19
to jOOQ User Group
Ok I have found solution I use plugin to generate code but in project that use jooq class generated I remove plugin dependency from gradle

Thank
Nicola


Il giorno giovedì 25 luglio 2019 17:01:56 UTC+2, Lukas Eder ha scritto:
Hi Nicola,

Thank you for your follow up question. Would it be possible to show a complete example of what you've tried? It would certainly help reproducing the problem, given that you're now using 2 third party components that have various ways of interacting badly with each other.From your email, I'm not sure what could be the reason that you're getting the wrong artifact on your classpath.

Thanks,
Lukas

Lukas Eder

unread,
Jul 26, 2019, 10:45:30 AM7/26/19
to jOOQ User Group
Interesting, thank you very much for documenting this here!

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/8721f7fd-6bac-4d87-9945-96f0342f9237%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages