Bugs fixed:
Character sets read from database if
useUnicode=trueandcharacterEncodingis not set. (thanks to Dmitry Vereshchagin)Initial transaction isolation level read from database (if available). (thanks to Dmitry Vereshchagin)
Fixed
PreparedStatementgenerating SQL that would end up with syntax errors for some queries.PreparedStatement.setCharacterStream()now implementedCaptialize type names when
captializeTypeNames=trueis passed in URL or properties (for WebObjects. (thanks to Anjo Krank)ResultSet.getBlob()now returnsnullif column value wasnull.Fixed
ResultSetMetaData.getPrecision()returning one less than actual on newer versions of MySQL.Fixed dangling socket problem when in high availability (
autoReconnect=true) mode, and finalizer forConnectionwill close any dangling sockets on GC.Fixed time zone issue in
PreparedStatement.setTimestamp(). (thanks to Erik Olofsson)PreparedStatement.setDouble() now uses full-precision doubles (reverting a fix made earlier to truncate them).
Fixed
DatabaseMetaData.supportsTransactions(), andsupportsTransactionIsolationLevel()andgetTypeInfo()SQL_DATETIME_SUBandSQL_DATA_TYPEfields not being readable.Updatable result sets now correctly handle
NULLvalues in fields.PreparedStatement.setBoolean() will use 1/0 for values if your MySQL version is 3.21.23 or higher.
Fixed
ResultSet.isAfterLast()always returningfalse.