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 (20 chapters)
close
close
close
JDBC 4.0 and Oracle JDeveloper for J2EE Development
Icon
JDBC 4.0 and Oracle JDeveloper for J2EE Development
Credits
Icon
Credits
About the Author
Icon
About the Author
About the Reviewer
Icon
About the Reviewer
Preface
Icon
Preface
Lock Free Chapter
1
JDBC 4.0
Icon
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
Configuring JDBC in Oracle JDeveloper
Icon
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
Connecting to a Database with JSTL SQL Tag Library
Icon
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
Configuring JDBC in JBoss Application Server
Icon
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
Configuring JDBC in WebLogic Server
Icon
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
Configuring JDBC in WebSphere Application Server
Icon
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
XML SQL Utility
chevron up
Icon
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
XSQL
Icon
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
Oracle Web RowSet
Icon
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
Creating a JSF Data Table
Icon
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
Creating a JSF Panel Grid
Icon
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
Creating a Report with JasperReports
Icon
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
Creating a Spreadsheet with Apache POI
Icon
Creating a Spreadsheet with Apache POI
Icon
Setting the Environment
Icon
Creating an Excel Spreadsheet
Icon
JDBC 4.0 Version
Icon
Summary
14
Creating Oracle ADF Business Components
Icon
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
Hibernate
Icon
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

XML Document to SQL Database Mapping

If the XML document had been stored with XSU, only the element tags in the XML document would have got stored. The attributes in the XML document would not have got stored. Attributes in an XML document can be stored by mapping them to elements. The attributes can be converted to elements by applying an XSLT stylesheet to the XML document. This section discusses the procedure to store an XML document with attributes in a database table. The XML document is stored in a database table using the OracleXMLSave class, which is imported in the XMLToDatabase.java application.

Create a connection with the database. If we were using a JDBC 3.0 driver, we would have registered the Oracle JDBC driver with DriverManager using the registerDriver(Driver) method. JDBC 4.0 adds support for automatic driver registration using the Java SE Service Provider mechanism. The Oracle database 11g JDBC 4.0 drivers JAR file, ojdbc6.jar, includes a META-INF/services/java.sql.Driver...

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