SimpleNativeJdbcExtractor

Class Overview

Simple implementation of the NativeJdbcExtractor interface. Assumes a pool that wraps Connection handles but not DatabaseMetaData: In this case, the underlying native Connection can be retrieved by simply calling conHandle.getMetaData().getConnection(). All other JDBC objects will be returned as passed in.

This extractor should work with any pool that does not wrap DatabaseMetaData, and will also work with any plain JDBC driver. Note that a pool can still wrap Statements, PreparedStatements, etc: The only requirement of this extractor is that java.sql.DatabaseMetaData does not get wrapped, returning the native Connection of the JDBC driver on metaData.getConnection().

Customize this extractor by setting the "nativeConnectionNecessaryForXxx" flags accordingly: If Statements, PreparedStatements, and/or CallableStatements are wrapped by your pool, set the corresponding "nativeConnectionNecessaryForXxx" flags to "true". If none of the statement types is wrapped - or you solely need Connection unwrapping in the first place -, the defaults are fine.

SimpleNativeJdbcExtractor is a common choice for use with OracleLobHandler, which just needs Connection unwrapping via the getNativeConnectionFromStatement(Statement) method. This usage will work with almost any connection pool. Known to work are, for example:

• Caucho Resin 2.1.x, 3.0.x
• Sun Java System Application Server 8
• Oracle OC4J 9.0.3, 9.0.4
• C3P0 0.8.x
• Jakarta Commons DBCP 1.0, 1.1, 1.2 (used in Tomcat 4.1.x, 5.0.x)
• JBoss 3.2.x

For full usage with JdbcTemplate, i.e. to also provide Statement unwrapping:

• Use a default SimpleNativeJdbcExtractor for Resin and SJSAS (no JDBC Statement objects are wrapped, therefore no special unwrapping is necessary).
• Use a SimpleNativeJdbcExtractor with all "nativeConnectionNecessaryForXxx" flags set to "true" for OC4J and C3P0 (all JDBC Statement objects are wrapped, but none of the wrappers allow for unwrapping).
• Use a CommonsDbcpNativeJdbcExtractor for Jakarta Commons DBCP respectively a JBossNativeJdbcExtractor for JBoss (all JDBC Statement objects are wrapped, but all of them can be extracted by casting to implementation classes).

Summary

[Expand] Inherited Methods
From class org.springframework.jdbc.support.nativejdbc.NativeJdbcExtractorAdapter Connection doGetNativeConnection(Connection con) Not able to unwrap: return passed-in Connection. CallableStatement getNativeCallableStatement(CallableStatement cs) Not able to unwrap: return passed-in CallableStatement. Connection getNativeConnection(Connection con) Check for a ConnectionProxy chain, then delegate to doGetNativeConnection. Connection getNativeConnectionFromStatement(Statement stmt) Retrieve the Connection via the Statement's Connection. PreparedStatement getNativePreparedStatement(PreparedStatement ps) Not able to unwrap: return passed-in PreparedStatement. ResultSet getNativeResultSet(ResultSet rs) Not able to unwrap: return passed-in ResultSet. Statement getNativeStatement(Statement stmt) Not able to unwrap: return passed-in Statement. boolean isNativeConnectionNecessaryForNativeCallableStatements() Return false by default. boolean isNativeConnectionNecessaryForNativePreparedStatements() Return false by default. boolean isNativeConnectionNecessaryForNativeStatements() Return false by default.
From class java.lang.Object Object clone() boolean equals(Object arg0) void finalize() final Class<?> getClass() int hashCode() final void notify() final void notifyAll() String toString() final void wait() final void wait(long arg0, int arg1) final void wait(long arg0)
From interface org.springframework.jdbc.support.nativejdbc.NativeJdbcExtractor abstract CallableStatement getNativeCallableStatement(CallableStatement cs) Retrieve the underlying native JDBC CallableStatement for the given statement. abstract Connection getNativeConnection(Connection con) Retrieve the underlying native JDBC Connection for the given Connection. abstract Connection getNativeConnectionFromStatement(Statement stmt) Retrieve the underlying native JDBC Connection for the given Statement. abstract PreparedStatement getNativePreparedStatement(PreparedStatement ps) Retrieve the underlying native JDBC PreparedStatement for the given statement. abstract ResultSet getNativeResultSet(ResultSet rs) Retrieve the underlying native JDBC ResultSet for the given statement. abstract Statement getNativeStatement(Statement stmt) Retrieve the underlying native JDBC Statement for the given Statement. abstract boolean isNativeConnectionNecessaryForNativeCallableStatements() Return whether it is necessary to work on the native Connection to receive native CallableStatements. abstract boolean isNativeConnectionNecessaryForNativePreparedStatements() Return whether it is necessary to work on the native Connection to receive native PreparedStatements. abstract boolean isNativeConnectionNecessaryForNativeStatements() Return whether it is necessary to work on the native Connection to receive native Statements.