MySQL Connector/J 5.1 Release Notes

2.45 Changes in MySQL Connector/J 5.1.5 (2007-10-09)

New Features, Compared to the 5.0 Series of Connector/J

  • Support for JDBC-4.0 NCHAR, NVARCHAR and NCLOB types.

  • 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).

  • Support for JDBC-4.0 XML processing using JAXP interfaces to DOM, SAX and StAX.

  • JDBC-4.0 standardized unwrapping to interfaces that include vendor extensions.

Functionality Added or Changed

  • Added autoSlowLog configuration property, overrides slowQueryThreshold* properties, driver determines slow queries by those that are slower than 5 * stddev of the mean query time (outside the 96% percentile).

Bugs Fixed

  • When a connection is in read-only mode, queries that are wrapped in parentheses were incorrectly identified DML statements. (Bug #28256)

  • When calling 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 );
    

    (Bug #15604)