Can not issue data manipulation statements with executeQuery()

Shimun Matić

unread,

Dec 2, 2020, 11:21:24 AM12/2/20

to jOOQ User Group

Hello.

I've been using JOOQ with Spring for a few months now and everything was great until I upgraded the project to the latest Spring Boot version. (2.3.5 RELEASE to 2.4.0)

With the latest Spring release comes the latest JOOQ release (3.13.5 to 3.14.4)

I am facing the problem when I try to store a record. (Exception at the end of the post)

Important thing to note is that this only happens when I am not using autoconfiguration.

With JooqAutoConfiguration class enabled, everything works as expected.

Another important factor is the database. I am using MariaDB, tested with 10.1.38 and 10.5.x (docker latest).

What I had tried:

1. Downgraded JOOQ version to 3.13.x - worked as expected

2. Downgraded JOOQ version to 3.14.0 - same error

3. Used different DB (postgres) - worked as expected

So it seems to me that there has been some change in 3.14.x that broke the simplest (manual) DSL configuration for MariaDB (This configuration works with older version and with postgres).

I have made a simple project which showcases the problem.

GitHub

If you want to test the project:

1. jdbc url (pom and application.yml) has to be changed to point to your db

(or you can create test db with docker, this way URL stays the same:

docker run --name mariadb -e MYSQL_DATABASE=db_test -e MYSQL_ROOT_PASSWORD=password -d -p 3306:3306 mariadb:latest)

2. change java version to the one you have, 15 was used. (tested on JDK 11 too)

Does anybody know if I am missing something in the DSL configuration or is this a bug?

Thanks,

Shimun

Shimun Matić

unread,

Dec 2, 2020, 11:22:07 AM12/2/20

to jOOQ User Group

org.jooq.exception.DataAccessException: SQL [insert into `db_test`.`person` (`firstname`, `lastname`, `username`, `email`) values (?, ?, ?, ?) returning `id`]; Can not issue data manipulation statements with executeQuery().

at org.jooq_3.14.4.MARIADB.debug(Unknown Source)

at org.jooq.impl.Tools.translate(Tools.java:2904)

at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:757)

at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:389)

at org.jooq.impl.TableRecordImpl.storeInsert0(TableRecordImpl.java:218)

at org.jooq.impl.TableRecordImpl$1.operate(TableRecordImpl.java:183)

at org.jooq.impl.RecordDelegate.operate(RecordDelegate.java:131)

at org.jooq.impl.TableRecordImpl.storeInsert(TableRecordImpl.java:179)

at org.jooq.impl.UpdatableRecordImpl.store0(UpdatableRecordImpl.java:219)

at org.jooq.impl.UpdatableRecordImpl.access$000(UpdatableRecordImpl.java:89)

at org.jooq.impl.UpdatableRecordImpl$1.operate(UpdatableRecordImpl.java:145)

at org.jooq.impl.RecordDelegate.operate(RecordDelegate.java:131)

at org.jooq.impl.UpdatableRecordImpl.store(UpdatableRecordImpl.java:141)

at org.jooq.impl.UpdatableRecordImpl.store(UpdatableRecordImpl.java:133)

at com.example.jooqtest.JooqTestApplicationTests.testSavingToMariaDb(JooqTestApplicationTests.java:26)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:64)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:564)

at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:688)

at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)

at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131)

at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:149)

at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:140)

at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:84)

at org.junit.jupiter.engine.execution.ExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(ExecutableInvoker.java:115)

at org.junit.jupiter.engine.execution.ExecutableInvoker.lambda$invoke$0(ExecutableInvoker.java:105)

at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106)

at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64)

at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45)

at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37)

at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:104)

at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:98)

at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$6(TestMethodTestDescriptor.java:210)