ADF Business Components use JDBC to access the database. OC4J server embedded in JDeveloper 10g or JDeveloper does not support JDBC 4.0. The new features in JDBC 4.0 may be availed in a JDeveloper version that supports JDBC 4.0. To use JDBC 4.0 in ADF Business Components configure a database connection with the Oracle database 11g JDBC 4.0 drivers JAR file ojdbc6.jar. We also need to set JDK version to JDK 6.0. To set the JDK version select Tools | Project Properties. In the Project Properties window, select Libraries. In the J2SE Version field, click on Change to select a JDK 6.0 Java executable.

We would be able to use those JDBC 4.0 features that are implemented by the OC4J server. Connection state tracking is implemented by the connection pool manager and is used to track unusable connections. Prior to the new feature of connection state tracking a connection pool manager would typically close all the connections and reinitiate a connection pool if some of the connections...