PreparedStatement.setCharacterStream() now implemented

Fixed dangling socket problem when in high availability (autoReconnect=true) mode, and finalizer for Connection will close any dangling sockets on GC.

Fixed ResultSetMetaData.getPrecision() returning one less than actual on newer versions of MySQL.

ResultSet.getBlob() now returns null if column value was null.

Character sets read from database if useUnicode=true and characterEncoding is not set. (thanks to Dmitry Vereshchagin)

Initial transaction isolation level read from database (if avaialable). (thanks to Dmitry Vereshchagin)

Fixed DatabaseMetaData.supportsTransactions(), and supportsTransactionIsolationLevel() and getTypeInfo() SQL_DATETIME_SUB and SQL_DATA_TYPE fields not being readable.

Fixed PreparedStatement generating SQL that would end up with syntax errors for some queries.

Fixed ResultSet.isAfterLast() always returning false.

Fixed time zone issue in PreparedStatement.setTimestamp(). (thanks to Erik Olofsson)

Captialize type names when captializeTypeNames=true is passed in URL or properties (for WebObjects. (thanks to Anjo Krank)

Updatable result sets now correctly handle NULL values in fields.

PreparedStatement.setDouble() now uses full-precision doubles (reverting a fix made earlier to truncate them).

PreparedStatement.setBoolean() will use 1/0 for values if your MySQL version is 3.21.23 or higher.