JDBC 4.0 and Oracle JDeveloper for J2EE Development -- Table of Contents -- JDBC 4.0 and Oracle JDeveloper for J2EE Development -- Credits -- About the Author -- About the Reviewer -- Preface -- What This Book Covers -- Who is This Book for -- Conventions -- Reader Feedback -- Customer Support -- Downloading the Example Code for the Book -- Errata -- Questions -- 1. JDBC 4.0 -- DriverManager Class -- Connection Interface -- Transactions -- Savepoint Interface -- Statement Interface -- ResultSet Interface -- PreparedStatement Interface -- Database Metadata -- JDBC Exceptions -- New Features in JDBC 4.0 -- Automatic SQL Driver Loading -- Enhanced Data Type Support -- SQL: 2003 XML Data Type Support -- Generating an XML Document -- Storing an XML Document -- Retrieving an XML Document -- Accessing an XML Document Data -- Support for Wrapper Pattern -- Enhancements in SQLException -- Connection Management -- Scalar Functions -- JDBC 4.0 support in Oracle Database -- JDBC 4.0 support in MySQL Database -- JDBC 4.0 support in IBM's DB2 UDB -- Example Connection using a JDBC 4.0 Driver -- Summary -- 2. Configuring JDBC in Oracle JDeveloper -- Connection Pooling and DataSource -- Setting the Environment -- JDBC Configuration Errors -- Creating a Managed Data Source -- Connecting to a Database from a Web Application -- Setting J2SE Version to JDK 6.0 -- Developing and Running JSP -- JDBC 4.0 Version -- Summary -- 3. Connecting to a Database with JSTL SQL Tag Library -- Overview of JSTL SQL and Core Tags -- Setting the Environment -- Creating a Database Table -- Updating a Database Table -- Querying a Database Table -- Summary -- 4. Configuring JDBC in JBoss Application Server -- Deploying a Web Application to JBoss from JDeveloper -- JDBC 4.0 Version -- JBoss Deployment Descriptors for EJBs -- Configuring JBoss Server with Oracle Database.

Configuring JBoss Server with MySQL Database -- Configuring JBoss Server with PostgreSQL Database -- Configuring JBoss Server with DB2 Database -- Configuring JBoss Server with SQL Server -- Summary -- 5. Configuring JDBC in WebLogic Server -- Setting the Environment -- Creating a Data Source -- Configuring a Data Source -- Creating a Multi Data Source -- Performance Tuning JDBC -- Deploying a Web Application to WebLogic Server from JDeveloper -- JDBC 4.0 Version -- Summary -- 6. Configuring JDBC in WebSphere Application Server -- Setting the Environment -- Configuring a JDBC Provider -- Configuring a Data Source -- Deploying a Web Application to the WebSphere from JDeveloper -- JDBC 4.0 Version -- Summary -- 7. XML SQL Utility -- Setting the Environment -- XML Document to SQL Database Mapping -- Updating Database from XML Document -- Deleting a Row in a Database -- SQL Database to XML Document Mapping -- Summary -- 8. XSQL -- Overview of XSQL Tags -- Setting the Environment -- Configuring a Connection -- Creating XSQL Queries -- Applying XSQL Query Attributes -- Transforming XSQL Output -- JDBC 4.0 Version -- Summary -- 9. Oracle Web RowSet -- Setting the Environment -- Creating a Web RowSet -- Modifying a Database Table with Web RowSet -- Creating a New Row -- Reading a Row -- Updating a Row -- Deleting a Row -- Updating Database Table -- JDBC 4.0 Version -- Summary -- 10. Creating a JSF Data Table -- Setting the Environment -- Creating a Data Table by Binding a MBean -- Creating a Data Table with the JSF API -- JDBC 4.0 Version -- Summary -- 11. Creating a JSF Panel Grid -- Setting the Environment -- Creating a Panel Grid by Binding Rows -- Creating a Panel Grid by Binding a Managed Bean -- JDBC 4.0 Version -- Summary -- 12. Creating a Report with JasperReports -- Setting the Environment -- Installing JasperReports.

Configuring the JasperReports Configuration File -- Generating a PDF Report -- Creating an Excel Spreadsheet -- JDBC 4.0 Version -- Summary -- 13. Creating a Spreadsheet with Apache POI -- Setting the Environment -- Creating an Excel Spreadsheet -- JDBC 4.0 Version -- Summary -- 14. Creating Oracle ADF Business Components -- Setting the Environment -- Configuring a BC4J Project -- Creating Business Components -- Developing a BC4J Web Application -- JDBC 4.0 Version -- Summary -- 15. Hibernate -- Hibernate and JDBC -- Setting the Environment -- Developing Hibernate Mapping and Properties Files -- Creating a Database Table -- Modifying Table Data with Hibernate -- Adding Data to the Database Table -- Retrieving Data from the Database Table -- Updating the Database Table -- Deleting Data -- Summary -- Index.