JDBC 4.0 and Oracle JDeveloper for J2EE Development
上QQ阅读APP看书,第一时间看更新

JDBC 4.0 support in MySQL Database

MySQL database server provides support for the JDBC 4.0 specification in the Connector/J 5.1 JDBC drivers. MySQL's Connector/J 5.1 supports the JDBC 4.0 features, listed below:

  1. Auto-registration of the JDBC driver with the DriverManager via the J2SE Service Provider mechanism.
  2. Connection validity check using the isValid() method of the Connection interface.
  3. Categorized SQLExceptions based on recoverability or retry-ability, and class of the underlying error.
  4. Unwrapping of MySQL-specific extensions for JDBC.
  5. Support for SQLXML. MySQL database does not support the SQL: 2003 SQL data type XML. JDBC 4.0 specification does not specify that the SQL data type to store a SQLXML object is required to be the SQL: 2003 XML data type. MySQL's Connector/J 5.1 JDBC driver supports the SQLXML Java data type.
  6. Support for setting per-connection client info using the setClientInfo() method of the Connection interface.
  7. Support for National Character Set data types NCHAR, NVARCHAR, LONGNVARCHAR, and NCLOB.