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

regression in 3.x.y: nonparameterized batch "INSERT INTO products( name ) VALUES ( 'aaaa' )" fails

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.1.2
    • 3.3.3
    • 2.7 compatibility
    • None
    • win10pro[64bit], 10.5.4-MariaDB, java8

    Description

      regression.
      2.7.x connector works, 3.x.y connector fails to execute nonparameterized batch of statements "INSERT INTO products( name ) VALUES ( 'aaaa' )".

      OUTPUT when fails with connector driver ver. 3.1.2:

       running:
        SELECT version() as serverVersion
       Server version: [{serverVersion=10.5.4-MariaDB}]
       Driver version: 3.1.2
       running:
        DROP TABLE IF EXISTS products
       running:
        CREATE TABLE IF NOT EXISTS products (
          id       int unsigned AUTO_INCREMENT NOT NULL,
          name     varchar( 100 ) NOT NULL,
          created  datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
          PRIMARY KEY ( id )
        ) DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci
       running batch:
        INSERT INTO products( name ) VALUES ( 'aaaa' )
      [ WARN] (main) Error: 1295-HY000: This command is not supported in the prepared statement protocol yet
      Exception in thread "main" java.sql.BatchUpdateException: (conn=1336) This command is not supported in the prepared statement protocol yet
      	at org.mariadb.jdbc.export.ExceptionFactory.createBatchUpdate(ExceptionFactory.java:181)
      	at org.mariadb.jdbc.ClientPreparedStatement.executeBatchBulk(ClientPreparedStatement.java:179)
      	at org.mariadb.jdbc.ClientPreparedStatement.executeInternalPreparedBatch(ClientPreparedStatement.java:115)
      	at org.mariadb.jdbc.ClientPreparedStatement.executeBatch(ClientPreparedStatement.java:466)
      	at test.MariaDB_Regression1.runBatch(MariaDB_Regression1.java:86)
      	at test.MariaDB_Regression1.main(MariaDB_Regression1.java:106)
      Caused by: java.sql.BatchUpdateException: (conn=1336) This command is not supported in the prepared statement protocol yet
      	at org.mariadb.jdbc.export.ExceptionFactory.createBatchUpdate(ExceptionFactory.java:215)
      	at org.mariadb.jdbc.client.impl.StandardClient.executePipeline(StandardClient.java:620)
      	at org.mariadb.jdbc.ClientPreparedStatement.executeBatchBulk(ClientPreparedStatement.java:148)
      	... 4 more
      Caused by: java.sql.SQLException: (conn=1336) This command is not supported in the prepared statement protocol yet
      	at org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:299)
      	at org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:370)
      	at org.mariadb.jdbc.message.ClientMessage.readPacket(ClientMessage.java:134)
      	at org.mariadb.jdbc.client.impl.StandardClient.readPacket(StandardClient.java:855)
      	at org.mariadb.jdbc.client.impl.StandardClient.readResults(StandardClient.java:794)
      	at org.mariadb.jdbc.client.impl.StandardClient.readResponse(StandardClient.java:713)
      	at org.mariadb.jdbc.client.impl.StandardClient.executePipeline(StandardClient.java:571)
      	... 5 more
      
      

      Attachments

        Activity

          People

            diego dupin Diego Dupin
            dpichugin Dmitriy Pichugin
            Votes:
            1 Vote for this issue
            Watchers:
            1 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.