Download | Release Notes | Changelog |
Release date: 31 July 2017
MariaDB Connector/J 2.1.0 is a Stable (GA) release.
This version is a general availability (GA) release. (2.x version need java 8+)
When using ssl, driver check hostname against the server's identity as presented in the server's Certificate (checking alternative names or certificate CN) to prevent man-in-the-middle attack. Verification is disabled when the option "trustServerCertificate" is set.
A new option "disableSslHostnameVerification" permit to deactivate this validation.
When configuration with multi-master, Connection.isValid() will not only validate connection, but host state (@@wsrep_cluster_status). A connection to a node that is not in primary mode will return false (meaning that in pool, connection will be discarded)
ResultSet.update* methods aren't implemented statement using ResultSet.CONCUR_UPDATABLE are now able to update record. example:
Use dedicated protocol for batch insert when possible. (batch without Statement.RETURN_GENERATED_KEYS and streams) to have faster batch (significant only if server >= ).
A new option "useBulkStmts" permit to deactivate this functionality.
[] Connection.getCatalog() optimisation for 10.2+ server using new session_track_schema capabilities
[] Failover handle automatic reconnection on KILL command
[] isolation leak when using multiple pools on same VM on failover
[] regression on aurora Connection Connection.isReadOnly()
[] correcting issue that ended throwing "Unknown prepared statement handler given to mysqld_stmt_execute"
[] return rounded numeric when querying on a decimal field in place of throwing an exception for compatibility
Statement stmt = con.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery("SELECT age FROM TABLE2");
// rs will be scrollable, will not show changes made by others,
// and will be updatable
while(rs.next()){
//Retrieve by column name
int newAge = rs.getInt(1) + 5;
rs.updateDouble( 1 , newAge );
rs.updateRow();
}This page is: Copyright © 2025 MariaDB. All rights reserved.