MariaDB Connector/J 1.3.0 Release notes

Download Release Notes Changelog Connector/J Overview

Release date: 16 Nov 2015

MariaDB Connector/J 1.3.0 is a Stable (GA) release.

For a list of all changes made in this release, with links to detailed information on each push, see the changelog.

Notable changes and additions

This release includes the following major enhancements :

• Prepared statement on server side.
• Improving memory footprint
• New Date/Time/Timestamps implementation
• New failover options

Prepared statements on server side

A prepared statement is a feature used to execute the same (or similar) SQL statements repeatedly with high efficiency.

This functionality is now executed on the server side.

For example:

PreparedStatement pst = connection.prepareStatement("INSERT INTO exemple VALUES (?)");
int i=1000;
while(i>0) {
    pst.setInt(1, i--);
    pst.addBatch();
}           
pst.executeBatch();

When executing connection.prepareStatement the query will be sent to the server. The server will return a statement ID.

When executing executeBatch, only this statement ID will be sent with the query parameter.

This improves performance when many queries are to be executed.

The following new parameters have been added :

The prepared statement will be cached according to the above parameters.

Memory improvement

The memory footprint has been improved for query text and especially for prepared statements.

New Date/Time/Timestamps implementation

A new parameter is added :

There is no change when the parameter useLegacyDatetimeCode is not specified or is true (it is true by default). When this parameter is set to false in the JDBC connection string, the new implementation is used. Therefore, the time zone of the server will be used, taking into account the time changes.

Example with a particular timezone:

If Connector/Java is using the "Europe/Paris" timezone, server "Canada/Atlantic" (UTC recommended, but not mandatory).

TimeZone.setDefault(TimeZone.getTimeZone("Europe/Paris"));
connection.createStatement().execute("CREATE TABLE daylight (t1 TIMESTAMP(6), t2 DATETIME(6))");
PreparedStatement pst = connection.prepareStatement("INSERT INTO daylight VALUES (?, ?)");
pst.setTimestamp(1, Timestamp.valueOf("2015-03-29 01:45:00"));
pst.setTimestamp(2, Timestamp.valueOf("2015-03-29 03:15:00"));
...

Using useLegacyDatetimeCode=false or not will return the same result :

ResultSet res = connection.createStatement().executeQuery("SELECT * FROM daylight");
res.next();
assertEquals(res.getTimestamp(1),Timestamp.valueOf("2015-03-29 01:45:00"));
assertEquals(res.getTimestamp(2),Timestamp.valueOf("2015-03-29 01:45:00"));
res.next();
assertEquals(res.getTimestamp(1),Timestamp.valueOf("2015-03-29 03:15:00"));
assertEquals(res.getTimestamp(2),Timestamp.valueOf("2015-03-29 03:15:00"));

The difference will be on the saved data :

with useLegacyDatetimeCode=false:

with useLegacyDatetimeCode=true:

New failover options

AssureReadOnly parameter

A new parameter is added :

When switching host to a slave (by using "connection.setReadOnly(true);" for example), if the database permit it, the connector was always setting the connection in read-only mode, so an Exception will be thrown if a data modification is done on a slave.

To improve performance, this operation will not be performed if the parameter is a assureReadOnly false (default). It's up to you to configure the slaves servers in read_only mode.

Sequential failover parameter

A new type of failover implementation as been added : Sequential.

This permits failover WITHOUT loadbalancing.

the host will be connected in the order in which they were declared.

Example when using the jdbc url string "jdbc:mysql:replication:host1,host2,host3/test". When connecting, the driver will always try first host1, and if not available host2 and following. After a host fail, the driver will reconnect according to this order.

Example :

Connecting order:

• trying to connect to host1. Host1 is up, the driver will use this host.

• host1 fail. The driver will connect to Host2.

• host2 fail. If the host1 is not blacklisted anymore (timeout configure with the loadBalanceBlacklistTimeout parameter) the driver will try to connect to host1, and after host3. If host1 was blacklisted, driver would connect to host3 directly.