JDBC 4.0 and Oracle JDeveloper for J2EE Development


JDBC 4.0 and Oracle JDeveloper for J2EE Development
eBook: $26.99
Formats: PDF, PacktLib, ePub and Mobi formats
$17.55
save 35%!
Print + free eBook + free PacktLib access to the book: $71.98    Print cover: $44.99
$62.54
save 13%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • 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

Book Details

Language : English
Paperback : 444 pages [ 235mm x 191mm ]
Release Date : April 2008
ISBN : 1847194303
ISBN 13 : 9781847194305
Author(s) : Deepak Vohra
Topics and Technologies : All Books, Enterprise Products and Platforms, Oracle Fusion Middleware, Enterprise, Java, Oracle


Table of Contents

Preface
Chapter 1: JDBC 4.0
Chapter 2: Configuring JDBC in Oracle JDeveloper
Chapter 3: Connecting to a Database with JSTL SQL Tag Library
Chapter 4: Configuring JDBC in JBoss Application Server
Chapter 5: Configuring JDBC in WebLogic Server
Chapter 6: Configuring JDBC in WebSphere Application Server
Chapter 7: XML SQL Utility
Chapter 8: XSQL
Chapter 9: Oracle Web RowSet
Chapter 10: Creating a JSF Data Table
Chapter 11: Creating a JSF Panel Grid
Chapter 12: Creating a Report with JasperReports
Chapter 13: Creating a Spreadsheet with Apache POI
Chapter 14: Creating Oracle ADF Business Components
Chapter 15: Hibernate
Index
  • 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
      • Automatic SQL Driver Loading
      • Enhanced Data Type Support
      • SQL: 2003 XML Data Type Support
        • Generating an XML Document
        • Storing an XML Document
        • Retrieving an XML Document
        • Accessing an XML Document Data
      • Support for Wrapper Pattern
        • Enhancements in SQLException
        • Connection Management
        • Scalar Functions
      • JDBC 4.0 support in Oracle Database
      • JDBC 4.0 support in MySQL Database
      • JDBC 4.0 support in IBM's DB2 UDB
    • 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
      • Setting J2SE Version to JDK 6.0
      • Developing and Running JSP
    • JDBC 4.0 Version
    • Summary
  • Chapter 4: Configuring JDBC in JBoss Application Server
    • Deploying a Web Application to JBoss from JDeveloper
    • JDBC 4.0 Version
    • 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 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 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

Deepak Vohra

Deepak Vohra is a consultant and a principal member of the NuBean.com software company. Deepak is a Sun Certified Java Programmer and Web Component Developer, and has worked in the fields of XML and Java programming and J2EE for over five years. Deepak is the co-author of the Apress book Pro XML Development with Java Technology and was the technical reviewer for the O'Reilly book WebLogic: The Definitive Guide. Deepak was also the technical reviewer for the Course Technology PTR book Ruby Programming for the Absolute Beginner, and the technical editor for the Manning Publications book Prototype and Scriptaculous in Action. Deepak is also the author of the Packt Publishing books JDBC 4.0 and Oracle JDeveloper for J2EE Development; Processing XML documents with Oracle JDeveloper 11g; EJB 3.0 Database Persistence with Oracle Fusion Middleware 11g; and Java 7 JAX-WS Web Services.

Sorry, we don't have any reviews for this title yet.

Code Downloads

Download the code and support files for this book.


Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

Frequently bought together

JDBC 4.0 and Oracle JDeveloper for J2EE Development +    Activiti 5.x Business Process Management Beginner's Guide =
50% Off
the second eBook
Price for both: $39.00

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

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.

This book is a practical reference guide to using Oracle JDeveloper IDE and JDBC 4.0 to develop J2EE data-driven applications.

Approach

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.

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. 

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software