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

    XMLWordPrintable

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

            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.