Like I said, I am testing it with the latest MariaDB version *10.5.8 *and the problem is still there. I have removed Spring from the project as I wanted to remove Spring as a factor. That is why I have created this plain Java project. To test JOOQ without Spring "interference" On Thursday, December 3, 2020 at 10:47:37 AM UTC+1 [email protected] wrote:
> 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/d88383ab-9d08-4f0c-ad8c-5445e5a43f78n%40googlegroups.com.
