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 | 
| 
 |