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...
JDBC 4.0 and Oracle JDeveloper for J2EE Development
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
Free Chapter
JDBC 4.0
Configuring JDBC in Oracle JDeveloper
Connecting to a Database with JSTL SQL Tag Library
Configuring JDBC in JBoss Application Server
Configuring JDBC in WebLogic Server
Configuring JDBC in WebSphere Application Server
XML SQL Utility
XSQL
Oracle Web RowSet
Creating a JSF Data Table
Creating a JSF Panel Grid
Creating a Report with JasperReports
Creating a Spreadsheet with Apache POI
Creating Oracle ADF Business Components
Hibernate
Customer Reviews