 | Level: Intermediate Victor J. Soderberg (victor_soderberg@yahoo.com), Freelance Writer, Freelance
29 Aug 2006 At the time of this writing, the Java™ Database Connectivity (JDBC) 4.0 specification is expected to be released from beta testing. It offers developers several enhancements to speed development and create a more object-oriented paradigm with regard to accessing and manipulating data stores. This specification relies heavily on existing technologies, such as Generics, the Metadata Facility, and JDBC RowSet. This tutorial demonstrates some of the new functions of the JDBC 4.0 specification in conjunction with the Apache Derby database.
Objectives - Learn about some of the new functions of the JDBC 4.0 specification in conjunction with the Apache Derby database.
- Learn about key methods and interfaces of the JDBC 4.0 release.
Prerequisites
This tutorial is for Java developers who have experience with accessing back-end systems for data extraction or manipulating. Furthermore, a basic understanding of SQL is required. Ideally, you should have experience with a prior version of one or more of the JDBC API's utilizing interfaces, such as ResultSet and Connection. In addition, a basic understanding of JSP technology is required.
System requirements
-
App server
- Java-compliant application servers meeting Java Servlet specification 2.3 and JSP specification 1.2 (minimally) should suffice with the included examples. All results in this document were generated with Jakarta's Tomcat 5.5.9.
-
Java
- The Java SE Development Kit (JDK 1.6) is used in this tutorial (specifically, beta2-b86). As mentioned above, this tutorial uses JSP for the code snippets for ease of integrating these samples to your Web-based app.
-
Database
- This tutorial uses Apache Derby 10.2.03 (beta release), which is open source and lightweight. Read the getstarted guide to declare and configure system variables. The derbyadmin tutorial will demonstrate how to configure/run a database server. This tutorial was created using the SimpleNetworkServerSample (embedded connection).
Duration
Under 2 hours
Formats html, pdf
| | | |
