Don't enable server-side prepared statements for server version 5.0.0 or 5.0.1, as they aren't compatible with the '4.1.2+' style that the driver uses (the driver expects information to come back that isn't there, so it hangs). (Bug #3804)
DataTruncation. (Bug #3804)
getProcedureColumns()doesn't work with wildcards for procedure name. (Bug #3540)
getProcedures()does not return any procedures in result set. (Bug #3539)
DatabaseMetaData.getProcedures()when run on MySQL-5.0.0 (output of
SHOW PROCEDURE STATUSchanged between 5.0.0 and 5.0.1. (Bug #3520)
connectionCollationproperty to cause driver to issue
set collation_connection=...query on connection init if default collation for given charset is not appropriate. (Bug #3520)
DBMD.getSQLStateType()returns incorrect value. (Bug #3520)
Correctly map output parameters to position given in
prepareCall()versus. order implied during
registerOutParameter(). (Bug #3146)
Cleaned up detection of server properties. (Bug #3146)
Correctly detect initial character set for servers >= 4.1.0. (Bug #3146)
Support placeholder for parameter metadata for server >= 4.1.2. (Bug #3146)
Removed wrapping of exceptions in
ServerPreparedStatement, which should help if you're trying to debug a query that is a prepared statement (it shows SQL as the server would process).
logSlowQueriesproperty, along with
slowQueriesThresholdMillisproperty to control when a query should be considered “slow.”
Fixed sending of split packets for large queries, enabled nio ability to send large packets as well.
ServerPreparedStatementsweren't actually de-allocating server-side resources when
Fixed case when no parameters could cause a
Fixed stored procedure parameter parsing info when size was specified for a parameter (for example,
Enabled callable statement caching using
gatherPerformanceMetricsproperty, along with properties to control when/where this info gets logged (see docs for more info).
Fixed case when no output parameters specified for a stored procedure caused a bogus query to be issued to retrieve out parameters, leading to a syntax error from the server.