On Thu, Dec 3, 2020 at 10:16 AM Shimun Matić <[email protected]> wrote:
> > Hi Lukas, > > Thank you very much for responding so quick. > > So I checked which version of JOOQ comes with > spring-boot-starter-jooq:2.4.0. It is 3.14.3. source > <https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-jooq/2.4.0> > What does calling "mvn dependency:tree" say about the various versions on your classpath? > Since I tried the latest MariaDB version I don't think it has something to > do with compatibility or right dialect. > At the beginning I thought that it had something to do with Spring, so I > wanted to make sure. > That is why I removed Spring completely from test project I tried it with > the most minimal configuration. > Results are the same: > It works as expected with 3.13.6. Same issue with 3.14.4. > But that's what I'm saying. With jOOQ 3.13, we didn't produce the RETURNING clause in INSERT statements, when fetching generated keys. We called JDBC's Statement.getGeneratedKeys() instead. With 3.14, we started generating the much more powerful RETURNING clause. Your stack trace shows that the RETURNING clause is being generated in jOOQ 3.14.4. > Since the new JOOQ version works with Spring Autoconfiguration I have to > conclude that there is something missing in my configuration for v3.14.x, > something new I have to configure with newer JOOQ versions with MariaDB. > Project sample: Github <https://github.com/shimunmatic/jooq-test> > That project sample doesn't seem to use Spring, though? > Do you have any idea what that could be? > Irrespective of why you have 3.13 or 3.14 on your classpath, these versions of the jOOQ Open Source Edition do not support MariaDB 10.4 or less. I recommend using the jOOQ Professional Edition for MariaDB 10.4 support. Here's how to do that with maven: https://blog.jooq.org/2019/06/26/how-to-use-jooqs-commercial-distributions-with-spring-boot/ -- 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/CAB4ELO6nw%3DHe6dKWH7ZpReqnXCcUeTiZiF4rAco0zXB_H%3DFFcg%40mail.gmail.com.
