Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
3.1.2
-
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
|
|