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

Related Content you might be interested in

Current Title:

Small book image
JDBC 4.0 and Oracle JDeveloper for J2EE Development
Apr, 2008 | 448 pages
No titles found
Table of Contents (20 chapters)
JDBC 4.0 and Oracle JDeveloper for J2EE Development
JDBC 4.0 and Oracle JDeveloper for J2EE Development
Credits
Credits
About the Author
About the Author
About the Reviewer
About the Reviewer
Preface
Preface
Free Chapter
1
JDBC 4.0
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
Example Connection using a JDBC 4.0 Driver
Summary
2
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
Summary
3
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
Summary
4
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
Summary
5
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
Summary
6
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
Summary
7
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
Summary
8
XSQL
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
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
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
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
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
Creating a Spreadsheet with Apache POI
Setting the Environment
Creating an Excel Spreadsheet
JDBC 4.0 Version
Summary
14
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
Summary
15
Hibernate
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

Setting the Environment

Download JDeveloper 10.1.3 from: http://www.oracle.com/technology/software/products/jdev/index.html. Extract the JDeveloper zip file to a directory, which installs the JDeveloper IDE. Download the Oracle database. Install the Oracle database including the sample schemas. We need to copy the Oracle database 11g JDBC drivers JAR file, ojdbc6.jar, for JDBC 4.0 to C:\JDeveloper\j2ee\home\applib directory. Keep a copy of the JDBC JAR files and delete them from the C:\JDeveloper\jdbc\lib directory. Copy back the deleted JDBC JAR files to the directory after running the JSTL application. We also need to set the J2SE Version to JDK 6.0 as explained in Chapter 2. In JDeveloper, create a project for the JSTL SQL taglib. Select File | New, and in the New Gallery window, select General in the Categories list and Application in the Items list. Click on OK button. In the Create Application window, specify an Application Name, JSTLApp, and click on OK. In the Create Project window...

Previous Section
End of Section 3
Next Section