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

Package org.springframework.jdbc.support.nativejdbc

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

org.springframework.jdbc.support.nativejdbc.NativeJdbcExtractor
Interface for extracting native JDBC objects from wrapped objects coming from connection pools. This is necessary to allow for casting to native implementations like OracleConnection or OracleResultSet in application code, for example to create Blobs or to access vendor-specific features.
Note: Setting a custom NativeJdbcExtractor is just necessary if you intend to cast to database-specific implementations like OracleConnection or OracleResultSet. Otherwise, any wrapped JDBC object will be fine, with no need for unwrapping.
Note: To be able to support any pool's strategy of native ResultSet wrapping, it is advisable to get both the native Statement and the native ResultSet via this extractor. Some pools just allow to unwrap the Statement, some just to unwrap the ResultSet - the above strategy will cover both. It is typically not necessary to unwrap the Connection to retrieve a native ResultSet.
When working with a simple connection pool that wraps Connections but not Statements, a {@link SimpleNativeJdbcExtractor} is often sufficient. However,some pools (like Jakarta's Commons DBCP) wrap all JDBC objects that they return: Therefore, you need to use a specific NativeJdbcExtractor (like {@link CommonsDbcpNativeJdbcExtractor}) with them.
{@link org.springframework.jdbc.core.JdbcTemplate} can properly apply aNativeJdbcExtractor if specified, unwrapping all JDBC objects that it creates. Note that this is just necessary if you intend to cast to native implementations in your data access code.
{@link org.springframework.jdbc.support.lob.OracleLobHandler}, the Oracle-specific implementation of Spring's {@link org.springframework.jdbc.support.lob.LobHandler} interface, requires aNativeJdbcExtractor for obtaining the native OracleConnection. This is also necessary for other Oracle-specific features that you may want to leverage in your applications, such as Oracle InterMedia. @author Juergen Hoeller @since 25.08.2003 @see SimpleNativeJdbcExtractor @see CommonsDbcpNativeJdbcExtractor @see org.springframework.jdbc.core.JdbcTemplate#setNativeJdbcExtractor @see org.springframework.jdbc.support.lob.OracleLobHandler#setNativeJdbcExtractor

      super.initializeWithTableColumnMetaData(databaseMetaData, catalogName, schemaName, tableName);
      return;
    }


    Connection con = databaseMetaData.getConnection();
    NativeJdbcExtractor nativeJdbcExtractor = getNativeJdbcExtractor();
    if (nativeJdbcExtractor != null) {
      con = nativeJdbcExtractor.getNativeConnection(con);
    }
    boolean isOracleCon;
    try {
      Class<?> oracleConClass = getClass().getClassLoader().loadClass("oracle.jdbc.OracleConnection");
      isOracleCon = oracleConClass.isInstance(con);

View Full Code Here

    mockConnection.createStatement();
    ctrlConnection.setReturnValue(mockStatement, 1);
    replay();


    JdbcTemplate template = new JdbcTemplate(mockDataSource);
    template.setNativeJdbcExtractor(new NativeJdbcExtractor() {
      public boolean isNativeConnectionNecessaryForNativeStatements() {
        return false;
      }
      public boolean isNativeConnectionNecessaryForNativePreparedStatements() {
        return false;

View Full Code Here

      super.initializeWithTableColumnMetaData(databaseMetaData, catalogName, schemaName, tableName);
      return;
    }


    Connection con = databaseMetaData.getConnection();
    NativeJdbcExtractor nativeJdbcExtractor = getNativeJdbcExtractor();
    if (nativeJdbcExtractor != null) {
      con = nativeJdbcExtractor.getNativeConnection(con);
    }
    boolean isOracleCon;
    try {
      Class<?> oracleConClass = con.getClass().getClassLoader().loadClass("oracle.jdbc.OracleConnection");
      isOracleCon = oracleConClass.isInstance(con);

View Full Code Here

    given(callableStatement2.getResultSet()).willReturn(returnResultSet);
    given(callableStatement2.getUpdateCount()).willReturn(-1);


    given(this.connection.createStatement()).willReturn(this.statement);


    this.template.setNativeJdbcExtractor(new NativeJdbcExtractor() {
      @Override
      public boolean isNativeConnectionNecessaryForNativeStatements() {
        return false;
      }
      @Override

View Full Code Here

        Connection con = DataSourceUtils.getConnection(ds);
        Statement stmt = null;
        ResultSet rs = null;
        try {
            Connection conToUse = con;
            NativeJdbcExtractor nje = getNativeJdbcExtractor();
            if(nje != null && nje.isNativeConnectionNecessaryForNativeStatements()) {
                conToUse = nje.getNativeConnection(con);
            }
            stmt = conToUse.createStatement();
            applyStatementSettings(stmt);
            Statement stmtToUse = stmt;
            if(nje != null) {
                stmtToUse = nje.getNativeStatement(stmt);
            }
            rs = stmtToUse.executeQuery(sql);
            ResultSet rsToUse = rs;
            if(nje != null) {
                rsToUse = nje.getNativeResultSet(rs);
            }
            // warnings are handled after query execution but before data access
            handleWarnings(stmt);
            return new StatementCloseableIterator<T>(ds, con, stmt, rs, rsToUse, rowMapper);
        } catch(SQLException ex) {

View Full Code Here

        Connection con = DataSourceUtils.getConnection(ds);
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            Connection conToUse = con;
            NativeJdbcExtractor nje = getNativeJdbcExtractor();
            if(nje != null && nje.isNativeConnectionNecessaryForNativePreparedStatements()) {
                conToUse = nje.getNativeConnection(con);
            }
            ps = psc.createPreparedStatement(conToUse);
            applyStatementSettings(ps);
            PreparedStatement psToUse = ps;
            if(nje != null) {
                psToUse = nje.getNativePreparedStatement(ps);
            }
            if(pss != null) {
                pss.setValues(psToUse);
            }
            rs = psToUse.executeQuery();
            ResultSet rsToUse = rs;
            if(nje != null) {
                rsToUse = nje.getNativeResultSet(rs);
            }
            // warnings are handled after query execution but before data access
            handleWarnings(ps);
            return new PreparedStatementCloseableIterator<T>(ds, con, psc, pss, ps, rs, rsToUse, rowMapper);
        } catch(SQLException ex) {

View Full Code Here

        Connection con = DataSourceUtils.getConnection(ds);
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            Connection conToUse = con;
            NativeJdbcExtractor nje = getNativeJdbcExtractor();
            if(nje != null && nje.isNativeConnectionNecessaryForNativePreparedStatements()) {
                conToUse = nje.getNativeConnection(con);
            }
            ps = psc.createPreparedStatement(conToUse);
            applyStatementSettings(ps);
            PreparedStatement psToUse = ps;
            if(nje != null) {
                psToUse = nje.getNativePreparedStatement(ps);
            }
            if(pss != null) {
                pss.setValues(psToUse);
            }
            rs = psToUse.executeQuery();
            ResultSet rsToUse = rs;
            if(nje != null) {
                rsToUse = nje.getNativeResultSet(rs);
            }
            // warnings are handled after query execution but before data access
            handleWarnings(ps);
            return new PreparedStatementCloseableIterator<T>(ds, con, psc, pss, ps, rs, rsToUse, rowMapper);
        } catch(SQLException ex) {

View Full Code Here

        Connection con = DataSourceUtils.getConnection(ds);
        Statement stmt = null;
        ResultSet rs = null;
        try {
            Connection conToUse = con;
            NativeJdbcExtractor nje = getNativeJdbcExtractor();
            if(nje != null && nje.isNativeConnectionNecessaryForNativeStatements()) {
                conToUse = nje.getNativeConnection(con);
            }
            stmt = conToUse.createStatement();
            applyStatementSettings(stmt);
            Statement stmtToUse = stmt;
            if(nje != null) {
                stmtToUse = nje.getNativeStatement(stmt);
            }
            rs = stmtToUse.executeQuery(sql);
            ResultSet rsToUse = rs;
            if(nje != null) {
                rsToUse = nje.getNativeResultSet(rs);
            }
            // warnings are handled after query execution but before data access
            handleWarnings(stmt);
            return new StatementCloseableIterator<T>(ds, con, stmt, rs, rsToUse, rowMapper);
        } catch(SQLException ex) {

View Full Code Here

            "check canUnwrap before calling unwrap");
    }


    private Connection unwrapInternal(Connection conn) {
        for (int i = 0; i < EXTRACTORS.size(); i++) {
            NativeJdbcExtractor extractor = EXTRACTORS.get(i);
            try {
                // the contract is that the original connection is returned
                // if unwrapping was not possible
                Connection unwrapped = extractor.getNativeConnection(conn);
                
                if(conn != unwrapped) {
                    if(i != 0) {
                        // move the extractor to the top, so that we don't do
                        // many useless attempts at unwrapping with the others

View Full Code Here

                "check canUnwrap before calling unwrap");
    }
    
    private Statement unwrapInternal(Statement st) {
        for (int i = 0; i < EXTRACTORS.size(); i++) {
            NativeJdbcExtractor extractor = EXTRACTORS.get(i);
            try {
                // the contract is that the original connection is returned
                // if unwrapping was not possible
                Statement unwrapped = extractor.getNativeStatement(st);
                if(st != unwrapped) {
                    if(i != 0) {
                        // move the extractor to the beginning, so that we don't do
                        // many useless attempts at unwrapping with the others
                        // (this code is typically executed for each feature)

View Full Code Here

0 1

TOP

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

com.alexkasko.springjdbc.iterable.IterableJdbcTemplate

org.geoserver.data.jdbc.SpringUnWrapper

org.springframework.jdbc.core.JdbcTemplateTests

org.springframework.jdbc.core.metadata.OracleTableMetaDataProvider

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.