Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Not a Bug
-
3.0.4
Description
Getting Invalid fetch size issue, when trying to setup an java application that uses infinisapn 9.4.4-Final to take care of cache related table with below JDBC URL using mariadb driver 3.0.4
jdbc:mysql://localhost:3307/demo_test_01?permitMysqlScheme
but when i try to install same application with below jdbc URL, it start successfully using mariadb driver 3.0.4
jdbc:mariadb://localhost:3307/demo_test_02?useMysqlMetadata
MariaDB server version: 10.7.3-MariaDB-1:10.7.3+maria~focal
And MariaDB connect/j --> 3.0.4 & 3.0.5
Observation:
- "jdbc:mysql://localhost:3307/demo_test_01" work fine for same application when using mariadb driver 2.7.3
- Also unable to fetch tables details when used database tool of IntelliJ IDEA with driver 3.0.4
- as well as invalid fetch size error in console
Caused by: java.sql.SQLSyntaxErrorException: (conn=65) invalid fetch size |
at org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:280) |
at org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:334) |
at org.mariadb.jdbc.Statement.setFetchSize(Statement.java:570) |
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) |
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) |
at java.base/java.lang.reflect.Method.invoke(Method.java:566) |
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:118) |
at com.sun.proxy.$Proxy47.setFetchSize(Unknown Source)
|
at com.dummy.app.server.database.wrapping.DummyStatementWrapper.setFetchSize(DummyStatementWrapper.java:403) |
at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.lambda$publish$1(JdbcStringBasedStore.java:533) |
at io.reactivex.internal.operators.flowable.FlowableUsing.subscribeActual(FlowableUsing.java:58) |
at io.reactivex.Flowable.subscribe(Flowable.java:14409) |
at io.reactivex.internal.operators.flowable.FlowableTake.subscribeActual(FlowableTake.java:33) |
at io.reactivex.Flowable.subscribe(Flowable.java:14409) |
at io.reactivex.internal.operators.flowable.FlowableDoOnEach.subscribeActual(FlowableDoOnEach.java:50) |
at io.reactivex.Flowable.subscribe(Flowable.java:14409) |
at io.reactivex.internal.operators.flowable.FlowableCountSingle.subscribeActual(FlowableCountSingle.java:34) |
at io.reactivex.Single.subscribe(Single.java:3394) |
at io.reactivex.Single.blockingGet(Single.java:2655) |