Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

JDBC 4.0 and Oracle JDeveloper for J2EE Development

By : Deepak Vohra

3 (2)

JDBC 4.0 and Oracle JDeveloper for J2EE Development

3 (2)

By: Deepak Vohra

Overview of this book

Being a quick reference guide, this book has a focused approach. You will learn to develop J2EE applications with JDBC and JDeveloper in no time. The book covers lot of practical examples, which makes it developer-friendly learning material. The book is suitable for Java/J2EE and Oracle JDeveloper beginners. If you are a J2EE developer and want to use the JDeveloper IDE for J2EE development, this book is for you. JDeveloper developers who are new to J2EE will also benefit from the book. Most J2EE applications have a database component and the book is specially suited for database-based J2EE development in Oracle JDeveloper. You can also use this book if you are interested in learning how to utilize the new features offered in JDBC 4.0 for Java/J2EE development.

Preface

Preface

What This Book Covers

Who is This Book for

Conventions

Reader Feedback

Customer Support

Free Chapter

1. JDBC 4.0

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

Example Connection using a JDBC 4.0 Driver

Summary

2. Configuring JDBC in Oracle JDeveloper

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

JDBC 4.0 Version

Summary

3. Connecting to a Database with JSTL SQL Tag Library

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

4. 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

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

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

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

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

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

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

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

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

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

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

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

Index

Connection Interface

The Connection interface represents a connection with the database. SQL statements may be run in a connection session by using a Statement object. A Connection object is in auto-commit mode, by default. In the auto-commit mode, changes are committed to the database after an SQL statement is executed. The auto-commit mode can be modified by calling the setAutoCommit(boolean autoCommit) method. For example, auto-commit may be set to false :

connection.setAutoCommit(false);

If auto-commit is set to false, it would be required to commit changes by calling the commit() method:

connection.commit();

A Connection object can be set to read-only by calling the setReadOnly() method:

connection.setReadOnly(true);

If a Connection object is not required, close the connection by calling the close() method:

connection.close();

The following table discusses the methods in JDBC 4.0 that have been added to the Connection interface.

Method	Description
`createArrayOf()`	Creates a java.sql.Array object. java.sql.Array is the Java mapping for the SQL data type, ARRAY. The SQL3 data type ARRAY stores an array in a column.
`createBlob()`	Creates a Blob object.
`createClob()`	Creates a Clob object.
`createNClob()`	Creates an NClob object.
`createSQLXML()`	Creates a SQLXML object.
`createStruct()`	Creates a Struct object.
`isValid()`	Tests the validity of a connection.
`getClientInfo()`	Overloaded method returns a client info property, or a list of client info properties. Client info represents information, such as user name and application name about the client.
`setClientInfo()`	Overloaded method sets client info.

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

JDBC 4.0 and Oracle JDeveloper for J2EE Development

Search

Your notes and bookmarks