In the JDBC 4.0 version of the Apache POI application, we need to create a JDBC connection with Oracle database using the Oracle database 11g JDBC 4.0 drivers, which may be obtained from: http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_111060.html. Use the ojdbc6.jar
JDBC JAR file to configure a JDBC connection and data source with Oracle data source. As JDBC 4.0 drivers required JDK 6.0, set the J2SE Version to JDK 6.0 by selecting Tools | Project Properties. In the Project Properties window, select the Libraries node and select a JDK 6.0 Java executable in the J2SE Version field.
We will add the following JDBC 4.0 features to the Apache POI application:
Connection state tracking
Connection client identification using client info properties
Statement pooling
Wrapper pattern
Java SE chained exception facility
Connection state tracking is implemented by the connection pool manager and is used to identify connections that have become unusable in the connection...