Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-977

java.sql.SQLSyntaxErrorException: (conn=65) invalid fetch size

    XMLWordPrintable

Details

    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)
      

      Attachments

        Activity

          People

            diego dupin Diego Dupin
            Prasad Rahul
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.