Examples of org.springframework.jdbc.support.nativejdbc.SimpleNativeJdbcExtractor

Package org.springframework.jdbc.support.nativejdbc

Examples of org.springframework.jdbc.support.nativejdbc.SimpleNativeJdbcExtractor

org.springframework.jdbc.support.nativejdbc.SimpleNativeJdbcExtractor
Simple implementation of the {@link 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 {@link #getNativeConnectionFromStatement} method. This usage will workwith 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).
@author Juergen Hoeller @since 05.12.2003 @see #setNativeConnectionNecessaryForNativeStatements @see #setNativeConnectionNecessaryForNativePreparedStatements @see #setNativeConnectionNecessaryForNativeCallableStatements @see Jdbc4NativeJdbcExtractor @see org.springframework.jdbc.core.JdbcTemplate#setNativeJdbcExtractor @see org.springframework.jdbc.support.lob.OracleLobHandler#setNativeJdbcExtractor

 * @author Juergen Hoeller
 */
public class NativeJdbcExtractorTests extends TestCase {


  public void testSimpleNativeJdbcExtractor() throws SQLException {
    SimpleNativeJdbcExtractor extractor = new SimpleNativeJdbcExtractor();


    MockControl conControl = MockControl.createControl(Connection.class);
    Connection con = (Connection) conControl.getMock();
    MockControl dbmdControl = MockControl.createControl(DatabaseMetaData.class);
    DatabaseMetaData dbmd = (DatabaseMetaData) dbmdControl.getMock();
    MockControl con2Control = MockControl.createControl(Connection.class);
    Connection con2 = (Connection) con2Control.getMock();
    con.getMetaData();
    conControl.setReturnValue(dbmd, 2);
    dbmd.getConnection();
    dbmdControl.setReturnValue(con2, 2);
    conControl.replay();
    dbmdControl.replay();
    con2Control.replay();


    Connection nativeCon = extractor.getNativeConnection(con);
    assertEquals(con2, nativeCon);


    MockControl stmtControl = MockControl.createControl(Statement.class);
    Statement stmt = (Statement) stmtControl.getMock();
    stmt.getConnection();
    stmtControl.setReturnValue(con);
    stmtControl.replay();


    nativeCon = extractor.getNativeConnectionFromStatement(stmt);
    assertEquals(con2, nativeCon);


    Statement nativeStmt = extractor.getNativeStatement(stmt);
    assertEquals(nativeStmt, stmt);


    MockControl psControl = MockControl.createControl(PreparedStatement.class);
    PreparedStatement ps = (PreparedStatement) psControl.getMock();
    psControl.replay();


    PreparedStatement nativePs = extractor.getNativePreparedStatement(ps);
    assertEquals(ps, nativePs);


    MockControl csControl = MockControl.createControl(CallableStatement.class);
    CallableStatement cs = (CallableStatement) csControl.getMock();
    MockControl rsControl = MockControl.createControl(ResultSet.class);
    ResultSet rs = (ResultSet) rsControl.getMock();
    cs.getResultSet();
    csControl.setReturnValue(rs);
    csControl.replay();
    rsControl.replay();


    CallableStatement nativeCs = extractor.getNativeCallableStatement(cs);
    assertEquals(cs, nativeCs);


    ResultSet nativeRs = extractor.getNativeResultSet(cs.getResultSet());
    assertEquals(nativeRs, rs);


    conControl.verify();
    dbmdControl.verify();
    con2Control.verify();

View Full Code Here

        assertTrue(TransactionSynchronizationManager.isActualTransactionActive());
        Connection tCon = DataSourceUtils.getConnection(dsToUse);
        try {
          if (createStatement) {
            tCon.createStatement();
            assertEquals(con, new SimpleNativeJdbcExtractor().getNativeConnection(tCon));
          }
        }
        catch (SQLException ex) {
          throw new UncategorizedSQLException("", "", ex);
        }

View Full Code Here

        // something transactional
        assertEquals(con, DataSourceUtils.getConnection(ds));
        TransactionAwareDataSourceProxy dsProxy = new TransactionAwareDataSourceProxy(ds);
        try {
          assertEquals(con, ((ConnectionProxy) dsProxy.getConnection()).getTargetConnection());
          assertEquals(con, new SimpleNativeJdbcExtractor().getNativeConnection(dsProxy.getConnection()));
          // should be ignored
          dsProxy.getConnection().close();
        }
        catch (SQLException ex) {
          throw new UncategorizedSQLException("", "", ex);

View Full Code Here

        // something transactional
        assertEquals(con, DataSourceUtils.getConnection(ds));
        final TransactionAwareDataSourceProxy dsProxy = new TransactionAwareDataSourceProxy(ds);
        try {
          assertEquals(con, ((ConnectionProxy) dsProxy.getConnection()).getTargetConnection());
          assertEquals(con, new SimpleNativeJdbcExtractor().getNativeConnection(dsProxy.getConnection()));
          // should be ignored
          dsProxy.getConnection().close();
        }
        catch (SQLException ex) {
          throw new UncategorizedSQLException("", "", ex);
        }


        tt.execute(new TransactionCallbackWithoutResult() {
          protected void doInTransactionWithoutResult(TransactionStatus status) {
            // something transactional
            assertEquals(con, DataSourceUtils.getConnection(ds));
            try {
              assertEquals(con, ((ConnectionProxy) dsProxy.getConnection()).getTargetConnection());
              assertEquals(con, new SimpleNativeJdbcExtractor().getNativeConnection(dsProxy.getConnection()));
              // should be ignored
              dsProxy.getConnection().close();
            }
            catch (SQLException ex) {
              throw new UncategorizedSQLException("", "", ex);

View Full Code Here

        assertEquals(con, DataSourceUtils.getConnection(ds));
        final TransactionAwareDataSourceProxy dsProxy = new TransactionAwareDataSourceProxy(ds);
        dsProxy.setReobtainTransactionalConnections(true);
        try {
          assertEquals(con, ((ConnectionProxy) dsProxy.getConnection()).getTargetConnection());
          assertEquals(con, new SimpleNativeJdbcExtractor().getNativeConnection(dsProxy.getConnection()));
          // should be ignored
          dsProxy.getConnection().close();
        }
        catch (SQLException ex) {
          throw new UncategorizedSQLException("", "", ex);
        }


        tt.execute(new TransactionCallbackWithoutResult() {
          protected void doInTransactionWithoutResult(TransactionStatus status) {
            // something transactional
            assertEquals(con, DataSourceUtils.getConnection(ds));
            try {
              assertEquals(con, ((ConnectionProxy) dsProxy.getConnection()).getTargetConnection());
              assertEquals(con, new SimpleNativeJdbcExtractor().getNativeConnection(dsProxy.getConnection()));
              // should be ignored
              dsProxy.getConnection().close();
            }
            catch (SQLException ex) {
              throw new UncategorizedSQLException("", "", ex);

View Full Code Here

 */
public class NativeJdbcExtractorTests {


  @Test
  public void testSimpleNativeJdbcExtractor() throws SQLException {
    SimpleNativeJdbcExtractor extractor = new SimpleNativeJdbcExtractor();


    Connection con = mock(Connection.class);
    DatabaseMetaData dbmd = mock(DatabaseMetaData.class);
    Connection con2 = mock(Connection.class);
    given(con.getMetaData()).willReturn(dbmd);
    given(dbmd.getConnection()).willReturn(con2);


    Connection nativeCon = extractor.getNativeConnection(con);
    assertEquals(con2, nativeCon);


    Statement stmt = mock(Statement.class);
    given(stmt.getConnection()).willReturn(con);


    nativeCon = extractor.getNativeConnectionFromStatement(stmt);
    assertEquals(con2, nativeCon);


    Statement nativeStmt = extractor.getNativeStatement(stmt);
    assertEquals(nativeStmt, stmt);


    PreparedStatement ps = mock(PreparedStatement.class);


    PreparedStatement nativePs = extractor.getNativePreparedStatement(ps);
    assertEquals(ps, nativePs);


    CallableStatement cs = mock(CallableStatement.class);
    ResultSet rs = mock(ResultSet.class);
    given(cs.getResultSet()).willReturn(rs);


    CallableStatement nativeCs = extractor.getNativeCallableStatement(cs);
    assertEquals(cs, nativeCs);


    ResultSet nativeRs = extractor.getNativeResultSet(cs.getResultSet());
    assertEquals(nativeRs, rs);
  }

View Full Code Here

        assertTrue(TransactionSynchronizationManager.isActualTransactionActive());
        Connection tCon = DataSourceUtils.getConnection(dsToUse);
        try {
          if (createStatement) {
            tCon.createStatement();
            assertEquals(con, new SimpleNativeJdbcExtractor().getNativeConnection(tCon));
          }
        }
        catch (SQLException ex) {
          throw new UncategorizedSQLException("", "", ex);
        }

View Full Code Here

        // something transactional
        assertEquals(con, DataSourceUtils.getConnection(ds));
        TransactionAwareDataSourceProxy dsProxy = new TransactionAwareDataSourceProxy(ds);
        try {
          assertEquals(con, ((ConnectionProxy) dsProxy.getConnection()).getTargetConnection());
          assertEquals(con, new SimpleNativeJdbcExtractor().getNativeConnection(dsProxy.getConnection()));
          // should be ignored
          dsProxy.getConnection().close();
        }
        catch (SQLException ex) {
          throw new UncategorizedSQLException("", "", ex);

View Full Code Here

        // something transactional
        assertEquals(con, DataSourceUtils.getConnection(ds));
        final TransactionAwareDataSourceProxy dsProxy = new TransactionAwareDataSourceProxy(ds);
        try {
          assertEquals(con, ((ConnectionProxy) dsProxy.getConnection()).getTargetConnection());
          assertEquals(con, new SimpleNativeJdbcExtractor().getNativeConnection(dsProxy.getConnection()));
          // should be ignored
          dsProxy.getConnection().close();
        }
        catch (SQLException ex) {
          throw new UncategorizedSQLException("", "", ex);
        }


        tt.execute(new TransactionCallbackWithoutResult() {
          @Override
          protected void doInTransactionWithoutResult(TransactionStatus status) {
            // something transactional
            assertEquals(con, DataSourceUtils.getConnection(ds));
            try {
              assertEquals(con, ((ConnectionProxy) dsProxy.getConnection()).getTargetConnection());
              assertEquals(con, new SimpleNativeJdbcExtractor().getNativeConnection(dsProxy.getConnection()));
              // should be ignored
              dsProxy.getConnection().close();
            }
            catch (SQLException ex) {
              throw new UncategorizedSQLException("", "", ex);

View Full Code Here

        assertEquals(con, DataSourceUtils.getConnection(ds));
        final TransactionAwareDataSourceProxy dsProxy = new TransactionAwareDataSourceProxy(ds);
        dsProxy.setReobtainTransactionalConnections(true);
        try {
          assertEquals(con, ((ConnectionProxy) dsProxy.getConnection()).getTargetConnection());
          assertEquals(con, new SimpleNativeJdbcExtractor().getNativeConnection(dsProxy.getConnection()));
          // should be ignored
          dsProxy.getConnection().close();
        }
        catch (SQLException ex) {
          throw new UncategorizedSQLException("", "", ex);
        }


        tt.execute(new TransactionCallbackWithoutResult() {
          @Override
          protected void doInTransactionWithoutResult(TransactionStatus status) {
            // something transactional
            assertEquals(con, DataSourceUtils.getConnection(ds));
            try {
              assertEquals(con, ((ConnectionProxy) dsProxy.getConnection()).getTargetConnection());
              assertEquals(con, new SimpleNativeJdbcExtractor().getNativeConnection(dsProxy.getConnection()));
              // should be ignored
              dsProxy.getConnection().close();
            }
            catch (SQLException ex) {
              throw new UncategorizedSQLException("", "", ex);

View Full Code Here

TOP

Related Classes of org.springframework.jdbc.support.nativejdbc.SimpleNativeJdbcExtractor

org.springframework.jdbc.datasource.DataSourceTransactionManagerTests

org.springframework.jdbc.support.NativeJdbcExtractorTests

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.