Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying JDBC 4.0 and Oracle JDeveloper for J2EE Development
  • Table Of Contents Toc
JDBC 4.0 and Oracle JDeveloper for J2EE Development

JDBC 4.0 and Oracle JDeveloper for J2EE Development

By : Deepak Vohra
3 (2)
Buy this Book
close
close
JDBC 4.0 and Oracle JDeveloper for J2EE Development

JDBC 4.0 and Oracle JDeveloper for J2EE Development

3 (2)
By: Deepak Vohra
Buy this Book

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.
Table of Contents (17 chapters)
close
close
close
Preface
Icon
Preface
Icon
What This Book Covers
Icon
Who is This Book for
Icon
Conventions
Icon
Reader Feedback
Icon
Customer Support
Lock Free Chapter
1
1. JDBC 4.0
Icon
1. JDBC 4.0
Icon
DriverManager Class
Icon
Connection Interface
Icon
Transactions
Icon
Savepoint Interface
Icon
Statement Interface
Icon
ResultSet Interface
Icon
PreparedStatement Interface
Icon
Database Metadata
Icon
JDBC Exceptions
Icon
New Features in JDBC 4.0
Icon
Example Connection using a JDBC 4.0 Driver
Icon
Summary
2
2. Configuring JDBC in Oracle JDeveloper
Icon
2. Configuring JDBC in Oracle JDeveloper
Icon
Connection Pooling and DataSource
Icon
Setting the Environment
Icon
JDBC Configuration Errors
Icon
Creating a Managed Data Source
Icon
Connecting to a Database from a Web Application
Icon
JDBC 4.0 Version
Icon
Summary
3
3. Connecting to a Database with JSTL SQL Tag Library
Icon
3. Connecting to a Database with JSTL SQL Tag Library
Icon
Overview of JSTL SQL and Core Tags
Icon
Setting the Environment
Icon
Creating a Database Table
Icon
Updating a Database Table
Icon
Querying a Database Table
Icon
Summary
4
4. Configuring JDBC in JBoss Application Server
Icon
4. Configuring JDBC in JBoss Application Server
Icon
Deploying a Web Application to JBoss from JDeveloper
Icon
JBoss Deployment Descriptors for EJBs
Icon
Configuring JBoss Server with Oracle Database
Icon
Configuring JBoss Server with MySQL Database
Icon
Configuring JBoss Server with PostgreSQL Database
Icon
Configuring JBoss Server with DB2 Database
Icon
Configuring JBoss Server with SQL Server
Icon
Summary
5
5. Configuring JDBC in WebLogic Server
Icon
5. Configuring JDBC in WebLogic Server
Icon
Setting the Environment
Icon
Creating a Data Source
Icon
Configuring a Data Source
Icon
Creating a Multi Data Source
Icon
Performance Tuning JDBC
Icon
Deploying a Web Application to WebLogic Server from JDeveloper
Icon
JDBC 4.0 Version
Icon
Summary
6
6. Configuring JDBC in WebSphere Application Server
Icon
6. Configuring JDBC in WebSphere Application Server
Icon
Setting the Environment
Icon
Configuring a JDBC Provider
Icon
Configuring a Data Source
Icon
Deploying a Web Application to the WebSphere from JDeveloper
Icon
JDBC 4.0 Version
Icon
Summary
7
7. XML SQL Utility
Icon
7. XML SQL Utility
Icon
Setting the Environment
Icon
XML Document to SQL Database Mapping
Icon
Updating Database from XML Document
Icon
Deleting a Row in a Database
Icon
SQL Database to XML Document Mapping
Icon
Summary
8
8. XSQL
Icon
8. XSQL
Icon
Overview of XSQL Tags
Icon
Setting the Environment
Icon
Configuring a Connection
Icon
Creating XSQL Queries
Icon
Applying XSQL Query Attributes
Icon
Transforming XSQL Output
Icon
JDBC 4.0 Version
Icon
Summary
9
9. Oracle Web RowSet
Icon
9. Oracle Web RowSet
Icon
Setting the Environment
Icon
Creating a Web RowSet
Icon
Modifying a Database Table with Web RowSet
Icon
Creating a New Row
Icon
Reading a Row
Icon
Updating a Row
Icon
Deleting a Row
Icon
Updating Database Table
Icon
JDBC 4.0 Version
Icon
Summary
10
10. Creating a JSF Data Table
Icon
10. Creating a JSF Data Table
Icon
Setting the Environment
Icon
Creating a Data Table by Binding a MBean
Icon
Creating a Data Table with the JSF API
Icon
JDBC 4.0 Version
Icon
Summary
11
11. Creating a JSF Panel Grid
Icon
11. Creating a JSF Panel Grid
Icon
Setting the Environment
Icon
Creating a Panel Grid by Binding Rows
Icon
Creating a Panel Grid by Binding a Managed Bean
Icon
JDBC 4.0 Version
Icon
Summary
12
12. Creating a Report with JasperReports
Icon
12. Creating a Report with JasperReports
Icon
Setting the Environment
Icon
Installing JasperReports
Icon
Configuring the JasperReports Configuration File
Icon
Generating a PDF Report
Icon
Creating an Excel Spreadsheet
Icon
JDBC 4.0 Version
Icon
Summary
13
13. Creating a Spreadsheet with Apache POI
chevron up
Icon
13. Creating a Spreadsheet with Apache POI
Icon
Setting the Environment
Icon
Creating an Excel Spreadsheet
Icon
JDBC 4.0 Version
Icon
Summary
14
14. Creating Oracle ADF Business Components
Icon
14. Creating Oracle ADF Business Components
Icon
Setting the Environment
Icon
Configuring a BC4J Project
Icon
Creating Business Components
Icon
Developing a BC4J Web Application
Icon
JDBC 4.0 Version
Icon
Summary
15
15. Hibernate
Icon
15. Hibernate
Icon
Hibernate and JDBC
Icon
Setting the Environment
Icon
Developing Hibernate Mapping and Properties Files
Icon
Creating a Database Table
Icon
Modifying Table Data with Hibernate
Icon
Adding Data to the Database Table
Icon
Retrieving Data from the Database Table
Icon
Updating the Database Table
Icon
Deleting Data
Icon
Summary
16
Index
Icon
Index

JDBC 4.0 Version

In the JDBC 4.0 version of the Apache POI application, we need to create a JDBC connection with Oracle database using the Oracle database 11g JDBC 4.0 drivers, which may be obtained from: http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_111060.html. Use the ojdbc6.jar JDBC JAR file to configure a JDBC connection and data source with Oracle data source. As JDBC 4.0 drivers required JDK 6.0, set the J2SE Version to JDK 6.0 by selecting Tools | Project Properties. In the Project Properties window, select the Libraries node and select a JDK 6.0 Java executable in the J2SE Version field.

We will add the following JDBC 4.0 features to the Apache POI application:

  • Connection state tracking

  • Connection client identification using client info properties

  • Statement pooling

  • Wrapper pattern

  • Java SE chained exception facility

Connection state tracking is implemented by the connection pool manager and is used to identify connections that have become unusable in the connection...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 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
End of Section 13
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon