The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

Advanced database operations with JDBC

Robert Brunner (rjbrunner@pacbell.net), Astrophysicist , California Institute of Technology

Robert J. Brunner is an astrophysicist by day and a computer hacker by night. His principal employer is the California Institute of Technology, where he works on knowledge extraction and data-mining from large, highly distributed astronomical databases. He has provided consulting to scientific data centers around the world, provided Java and XML training to a variety of groups, and is currently working on the book Enterprise Java Database Programming which will be published by Addison Wesley in 2002.

Summary: This tutorial is designed to introduce you to several advanced database operations, including stored procedures and advanced datatypes, that can be performed by a Java application using JDBC.

Date: 19 Nov 2001
Level: Intermediate
PDF: A4 and Letter (236 KB | 25 pages)Get Adobe® Reader®

Activity: 12028 views
Comments:

Resources

Learn

Visit the official JDBC home page for the JDBC 2.0 and 3.0 specifications and other information.
JDBC API Tutorial and Reference, Second Edition (Addison-Wesley, 1999) by White, Fisher, Cattell, Hamilton, and Hapner is the reference for JDBC developers.
"Managing database connections with JDBC" (developerWorks, November 2001), another JDBC tutorial by Robert Brunner, provides an introduction to the different concepts involved in establishing and managing a database connection from within a Java application using JDBC.
"What's new in JDBC 3.0" (develperWorks, July 2001) by Josh Heidebrecht provides an overview of the new features and enhancements in the new spec.
"An easy JDBC wrapper" (developerWorks, August 2001) by Greg Travis describes a simple wrapper library that makes basic database usage a snap.
The Java application development with DB2 Web site provides an important collection of useful DB2 and Java links.
The Java Naming and Directory Interface (JNDI) Web site provides a wealth of information regarding naming services, including an excellent JNDI tutorial. To use the JNDI examples, you will need to download the filesystem context provider, which is available from the site.
The SQL Reference Page provides numerous links to general SQL topics and information, SQL syntax information, programming resources, the many different "blends" of SQL, SQL tools, and generic DBMS information.

Get products and technologies

Download the source code used in this tutorial, brunner2-code.zip.
To find a JDBC driver for a particular database, visit Sun's searchable database of JDBC drivers.
i-net software is another third-party vendor for JDBC drivers.
SourceForge offers an open source JDBC driver for the MySQL database.
Much of the example code in this tutorial was developed using DB2 Universal Database. If you're using this platform or wish to learn more about it from a technical perspective, visit the DB2 Developer Domain, a centralized technical resource for the DB2 developer community.