Free Sample
+ Collection

JDBC 4.0 and Oracle JDeveloper for J2EE Development

Starting
Deepak Vohra

A J2EE developer's guide to using Oracle JDeveloper's integrated database features to build data-driven applications with this book and eBook
$17.55
$44.99
RRP $26.99
RRP $44.99
eBook
Print + eBook

Want this title & more?

$16.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781847194305
Paperback444 pages

About This Book

  • Develop your Java applications using JDBC and Oracle JDeveloper
  • Explore the new features of JDBC 4.0
  • Use JDBC and the data tools in Oracle JDeveloper
  • Configure JDBC with various application servers
  • Build data-driven applications quickly and easily

Who This Book Is For

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

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

What You Will Learn

In this book you will learn about the following:

  • JDBC 4.0 specifications—including the new features
  • Configuring JDBC in Oracle JDeveloper IDE
  • Creating, modifying, and querying a database with the JSTL SQL Tag Library
  • Configuring JDBC in JBoss application server, WebLogic server, and WebSphere application server
  • Mapping an XML document to a database table and vice versa
  • Modifying a database table from an XML document and creating an XSQL Page to run an SQL Query and generate XML
  • Implementing Oracle Web RowSet to fetch the disconnected data
  • Creating Excel spreadsheets, PDFs, and Excel reports using JasperReports and the Apache POI HSSF library
  • Creating JSF Data Tables, JSF Panel Grids, and business components from Oracle databases with JDeveloper
  • Creating and managing database tables using Hibernate

In Detail

Data retrieval and storage is one of the most common components of J2EE applications. JDBC (Java Database Connectivity) is the Java API for accessing a SQL relational database and adding, retrieving, and updating data in the database.

Oracle JDeveloper is a developer-friendly integrated development environment (IDE) for building service-oriented applications using the latest industry standards for Java, XML, web services, and SQL. It supports the complete development lifecycle with integrated features for modeling, coding, debugging, testing, profiling, tuning, and deploying applications.

This book is about developing Java/J2EE applications with a database component in Oracle JDeveloper (version 10.1.3). It covers the practical aspects of JDBC (version 4.0); it will teach application developers about setting the environment for developing various JDBC-based J2EE applications and the procedure to develop JDBC-based J2EE applications. It will also explore the new features added in JDBC 4.0.

Authors

Read More