Lance Andersen's Blog

JDBC 4.0 Wrapper Interface

The following JDBC interfaces are subinterfaces of the Wrapper interface:

• java.sql.Connection
• java.sql.DatabaseMetaData
• java.sql.ParameterMetaData
• java.sql.ResultSet
• java.sql.ResultSetMetaData
• java.sql.Statement
• javax.sql.Datasource

The Wrapper interface consists of two methods:

• isWrapperFor - Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
• unwrap - Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.

  Statement stmt = conn.createStatement();
  Class clzz = Class.forName("oracle.jdbc.OracleStatement");
  OracleStatement os;
  if(stmt.isWrapperFor(clzz)) {
     os = stmt.unwrap(clzz);
     os.defineColumnType(1, Types.NUMBER);
  }

Comments

• I don't see how this would be useful. If you already decided to throw away the benefits of vendor independence in the first place, you don't need a standard way to do it.

  Posted by: erickson on February 26, 2006 at 12:26 PM

This work is licensed under a Creative Commons License.