New Features, Compared to the 5.0 Series of Connector/J
JDBC-4.0 standardized unwrapping to interfaces that include vendor extensions.
Support for JDBC-4.0 XML processing using JAXP interfaces to DOM, SAX and StAX.
JDBC-4.0 support for setting per-connection client information
(which can be viewed in the comments section of a query using
SHOW PROCESSLIST on a MySQL
server, or can be extended to support custom persistence of the
information using a public interface).
Functionality Added or Changed
autoSlowLog configuration property,
driver determines slow queries by those that are slower than 5 *
stddev of the mean query time (outside the 96% percentile).
setTimestamp on a prepared
statement, the timezone information stored in the calendar
object was ignored. This resulted in the incorrect
DATETIME information being stored. The
following example illustrates this:
Timestamp t = new Timestamp( cal.getTimeInMillis() ); ps.setTimestamp( N, t, cal );
When a connection is in read-only mode, queries that are wrapped in parentheses were incorrectly identified DML statements. (Bug #28256)