In this chapter, you have been introduced to the JDBC API and the new features in JDBC 4.0 specification. The DriverManager
class is used to connect with a database. The Connection
interface represents a database connection. The Savepoint
interface represents a savepoint in a transaction. This is the point up to which the changes would be rolled back, if the transaction is rolled back. The Statement
interface is used to run static SQL statements. The ResultSet
interface represents the result set table generated by running SQL statements on a database. The PreparedStatement
represents a compiled SQL statement that can be run more than once with different parameters. The DatabaseMetadata
interface represents the database metadata, such as, table name, schema name, column name, and column type. The SQLException
class represents the database access error or other SQL errors. JDBC 4.0 specification provides some new features to facilitate the development of JDBC applications. Support for new SQL data types has been added. The new features include, automatic SQL Driver loading, SQL: 2003 XML Data Type support, support for wrapper pattern, enhancements in SQLException
, and enhanced connection management.
JDBC 4.0 and Oracle JDeveloper for J2EE Development
JDBC 4.0 and Oracle JDeveloper for J2EE Development
Overview of this book
Table of Contents (20 chapters)
JDBC 4.0 and Oracle JDeveloper for J2EE Development
Credits
About the Author
About the Reviewer
Preface
Free Chapter
JDBC 4.0
Configuring JDBC in Oracle JDeveloper
Connecting to a Database with JSTL SQL Tag Library
Configuring JDBC in JBoss Application Server
Configuring JDBC in WebLogic Server
Configuring JDBC in WebSphere Application Server
XML SQL Utility
XSQL
Oracle Web RowSet
Creating a JSF Data Table
Creating a JSF Panel Grid
Creating a Report with JasperReports
Creating a Spreadsheet with Apache POI
Creating Oracle ADF Business Components
Hibernate
Customer Reviews