Connector/J 2.0.0 Release Notes

Download | Release Notes | Changelog |

Release date: 20 April 2017

MariaDB Connector/J 2.0.0-RC is an RC (Release candidate) release.

Notable Changes

Handle CLIENT_DEPRECATE_EOF flag

Implement some protocol changes that permit to save some bytes. (part of ).

handle SERVER_SESSION_STATE_CHANGE status flag

With server with version , MySQL 5.7, ensure driver state :

• driver does now always get current database, even when database is changed by query.

• when using rewriteBatchedStatements does return correct autoincrement ids even when session variable @auto_increment_increment has change during session.

improve setQueryTimeout to use SET STATEMENT max_statement_time

Previous implementation of query timeout handling (using Statement.setQueryTimeout) will create an additional thread with a scheduler. When timeout is reached, a temporary connection will be created to permit executing "KILL QUERY ", then closing the temporary connection. When query ended before timeout, the scheduled task will be canceled.

If server is > 10.1.2, query timeout will be handle server side using "SET MAX_STATEMENT_TIME FOR" command.

Real cancelling Streaming result sets

When closing a Statement that was fetching a result-set (using Statement.setFetchSize) and all rows where not read at the time of closing, a kill query command will be executed on close, to avoid having to parse all remaining results.

Memory optimization : streaming query

Very big command now doesn't use any intermediate buffer. Commands are send directly to socket avoiding using memory, This permit to send very large object (1G) without using any additional memory.

Faster connection

Faster connection : bundle first commands in authentication packet Driver execute different command on connection. Those queries are now send using pipeline (all queries are send, then only all results are reads).

New Options :

Performance improvement storing data in resultset

Parsing row result optimisation to avoid creating byte array to the maximum for faster results and less memory use.

Remaining JDBC 4.2 missing implementation :

• - support for large update count []

• - PrepareStatement.setObject(...) support for with java 8 temporal object.

• - support for Statement maxFieldSize

Misc

• - NullpointerException when making concurrent procedure calls

• - Improve connection using SELECT in place of SHOW to avoid creating a mutex server side.

• - tcpKeepAlive option now default to true.

• - QueryException: Incorrect arguments to mysqld_stmt_execute on inserting an "emptyString"-Lob with JPA