JDBC 4.0 and Oracle JDeveloper for J2EE Development

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

JDBC 4.0 and Oracle JDeveloper for J2EE Development

JDBC 4.0 and Oracle JDeveloper for J2EE Development

Credits

About the Author

About the Author

About the Reviewer

About the Reviewer

Preface

Free Chapter

JDBC 4.0

DriverManager Class

Connection Interface

Savepoint Interface

Statement Interface

ResultSet Interface

PreparedStatement Interface

Database Metadata

JDBC Exceptions

New Features in JDBC 4.0

Example Connection using a JDBC 4.0 Driver

Configuring JDBC in Oracle JDeveloper

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

JDBC 4.0 Version

Connecting to a Database with JSTL SQL Tag Library

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

Configuring JDBC in JBoss Application Server

Configuring JDBC in JBoss Application Server

Deploying a Web Application to JBoss from JDeveloper

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

Configuring JDBC in WebLogic Server

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

Configuring JDBC in WebSphere Application Server

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

XML SQL Utility

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

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

Oracle Web RowSet

Oracle Web RowSet

Setting the Environment

Creating a Web RowSet

Modifying a Database Table with Web RowSet

Creating a New Row

Updating Database Table

JDBC 4.0 Version

Creating a JSF Data Table

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

Creating a JSF Panel Grid

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

Creating a Report with JasperReports

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

Creating a Spreadsheet with Apache POI

Creating a Spreadsheet with Apache POI

Setting the Environment

Creating an Excel Spreadsheet

JDBC 4.0 Version

Creating Oracle ADF Business Components

Creating Oracle ADF Business Components

Setting the Environment

Configuring a BC4J Project

Creating Business Components

Developing a BC4J Web Application

JDBC 4.0 Version

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

Customer Reviews

5 star

0

4 star

0

3 star

0

2 star

0

1 star

0

JDBC 4.0 Version

In the JDBC 4.0 version of the JasperReports application, to generate a PDF report, use the Oracle database 11g JDBC 4.0 drivers JAR file, ojdbc6.jar, instead of the Oracle JDBC library. JDBC 4.0 drivers require JDK 6.0. Therefore, set the J2SE Version to JDK 6.0 in the Project Properties window. To modify the J2SE Version, select the Libraries node in Project Properties window. Click on the Change button for the J2SE Version field. In the Edit J2SE Definition window, click on New to create a J2SE definition for JDK 6.0. In the Create J2SE window, select a JDK 6.0 Java Executable and click on OK. Select the JDK 6.0 definition in Edit J2SE Definition window and click on OK. The J2SE Version gets set to JDK 6.0 in Project Properties window. Click on OK in Project Properties.

The JDBC 4.0 features can be availed in a JDeveloper version that supports JDBC 4.0 in the embedded OC4J. JDBC 4.0 provides enhanced connection management with connection state tracking and connection...