JDBC 4.0 and Oracle JDeveloper for J2EE Development

Table of Contents

• Preface

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 13: Creating a Spreadsheet with Apache POI
  • Setting the Environment
  • Creating an Excel Spreadsheet
  • JDBC 4.0 Version
  • Summary

• Chapter 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

• Chapter 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

Deepak Vohra

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

Find your book in our support section to find errata and to download code samples.