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

After upgrading to MariaDB JDBC Driver for Java version 3.1.0 I'm now receiving error message SQL state [HY000]; error code [1210] Incorrect arguments to mysqld_stmt_bulk_execute

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 3.1.0
    • 3.1.1
    • Other
    • None
    • Java 19.0.1 / JDBC Driver 3.1.0 / MariaDb 10.6.11

    Description

      Using the new JDBC Driver for Java version 3.1.0 I'm now receiving error message never seen before

      create table mytable
      (
      p7 bigint not null comment 'p7 Unique Id',
      p1 decimal(10,6) not null comment 'p1',
      p2 decimal(10,6) not null comment 'p2',
      p3 decimal(10,6) comment 'p3',
      p4 decimal(10,6) not null comment 'p4',
      p5 decimal(10,6) not null comment 'p5',
      p6 decimal(10,6) comment 'p6'
      ) ENGINE = MEMORY;

      INSERT INTO mytable (p1, p2, p3, p4, p5, p6, p7)
      VALUES (?, ?, ?, ?, ?, ?, ?);

      SQL state [HY000]; error code [1210]; (conn=8568) Incorrect arguments to mysqld_stmt_bulk_execute; nested exception is java.sql.BatchUpdateException: (conn=8568) Incorrect arguments to mysqld_stmt_bulk_execute;

      In Java the parameter p7 is a long primitive while parameter p1 to p6 are BigDecimal

      Some SQL insert succeed other failed.

      While using JDBC Driver version 3.0.8 I didn't have any problem

      I suspect it's related to CONN-1015 but don't have much more information

      JDBC Driver configuration

      useBulkStmts=true
      allowLocalInfile=false
      useCompression=true
      useServerPrepStmts=true
      useSSL=true
      trustServerCertificate=false
      enabledSslProtocolSuites=TLSv1.3

      Will provide soon more detailed information at trace level

      Attachments

        Issue Links

          Activity

            gjourdanweil Gaël Jourdan-Weil added a comment - - edited

            We are facing this issue as well when upgrading the client from 3.0.9 to 3.1.0.

            If needed I can try to provide reproduction cases.

            gjourdanweil Gaël Jourdan-Weil added a comment - - edited We are facing this issue as well when upgrading the client from 3.0.9 to 3.1.0. If needed I can try to provide reproduction cases.
            diego dupin Diego Dupin added a comment -

            Allright, after correcting CONJ-1035, this comes from the same problem.
            Correction is available through snapshot for now, and will be release in 3.1.1

            diego dupin Diego Dupin added a comment - Allright, after correcting CONJ-1035 , this comes from the same problem. Correction is available through snapshot for now, and will be release in 3.1.1

            Is it really fixed in 3.1.1? I don't see any reference to this issue in 3.1.1 changelog not commits history.

            gjourdanweil Gaël Jourdan-Weil added a comment - Is it really fixed in 3.1.1? I don't see any reference to this issue in 3.1.1 changelog not commits history.
            gigueret Thierry Giguere added a comment - I can see the fix for CONJ-1035 in the log. This is change https://github.com/mariadb-corporation/mariadb-connector-j/commit/7399a260

            Using the test provided in this issue, I confirmed that switching to version 3.1.1 now works. Thanks

            gigueret Thierry Giguere added a comment - Using the test provided in this issue, I confirmed that switching to version 3.1.1 now works. Thanks

            People

              diego dupin Diego Dupin
              gigueret Thierry Giguere
              Votes:
              2 Vote for this issue
              Watchers:
              4 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.