Book Image

JDBC 4.0 and Oracle JDeveloper for J2EE Development

Book Image

JDBC 4.0 and Oracle JDeveloper for J2EE Development

Overview of this book

Table of Contents (20 chapters)
JDBC 4.0 and Oracle JDeveloper for J2EE Development
Credits
About the Author
About the Reviewer
Preface

JDBC 4.0 Version


The OC4J server embedded in JDeveloper 10g or 11g does not support JDBC 4.0 specification; but in a later version of JDeveloper that supports JDBC 4.0, the JDBC 4.0 features may be added to the JSF application used to create a Data Table. JDBC 4.0 provides new features such as enhanced connection management, automatic driver loading, support for wrapper pattern, statement pooling, categorization of SQLExceptions and enhanced support for the Java SE chained exceptions facility. To use the JDBC 4.0 features you would need to download the Oracle database 11g JDBC 4.0 drivers JAR file, ojdbc6.jar from http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_111060.html. Copy ojdbc6.jar to the j2ee/home/lib directory, which is in the runtime class path of web applications running in OC4J server. As JDBC 4.0 drivers require JDK 6.0, we would also need to set J2SE version to JDK 6.0. To set the JDK version select Tools | Project Properties and select Libraries...