JDBC 4.0 Support

Wrapper Pattern interface

Provides a mechanism for accessing an instance of a resource, which may have been wrapped for architectural reasons. It provides a standard way to interface with proprietary or vendor-specific implementations, eliminating the need to write complex code and object casting.

LOB creation

A simplified connection interface makes it easier to create BLOB, CLOB and NCLOB objects. Additionally, you can free memory related to LOB types without having to wait for the JVM garbage collection process.

Statement pooling control

Provides control over whether individual statements are pooled. This leads to better performance because it minimizes the potential for a frequently used statement to be removed from the pool.

Connection is Valid

Determines whether a connection is valid using a JDBC standard API.

Connection Client Info

Get and set client information using standard JDBC 4.0 APIs. This functionality previously available as proprietary APIs, can be used to distinguish between connections in a pool that typically are created using the same user id and password. This information helps determine which application is using a connection, identify the source of a run-away query, and adjust the priority of work based on usage statistics. You can set client information through easily configurable connect options.

Auto Load Driver

Automatically load drivers by the Java SE 6 VM. This important ease-of-development feature eliminates the need to register the JDBC driver in the application.

SQLXML data type

JDBC 4.0 supports the SQLXML data type and provides Java XML bindings. This eliminates the need to use either JDBC driver extensions to transfer data or the CLOB interface, which is limited in nature to a string representation of the XML. Since the SQLXML data type is now a "first-class citizen" to JDBC, you can use standard DOM, SAX, StAX results and streams to process the data.

Data type support

Support for several data types and standard bindings for nationalized character sets, including NCHAR, NVARCHAR, NLONGVARCHAR and NCLOB. Native support for these data types allows the driver to work with the explicit data type, which results in better efficiency at run-time.

SQLException

Now provides finer grained control for managing SQL exceptions. The driver returns exceptions that are more specific, eliminating code that was necessary to determine the higher-level reason for the error. You can now check the SQLException vs. checking numerous different SQLStates. The exception handling now distinguishes between transient (might succeed if retried) or not transient (won't succeed if retried), so that errors that are "expected" or not can be processed more efficiently.

New JDBC 4.0 Types

Provides a standards-based way to set and retrieve JDBC 4.0 Types from all objects. Fully supported across all statement and resultSet object types.

New JDBC 4.0 Methods

New JDBC 4.0 methods make coding easier because the interfaces support more type conversions in the driver, removing the complexity of these conversions from the application.

Statement Event Listener

Supports the JDBC 4.0 Statement Event Listener.