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:

DB2 UDB V8.1 Family Application Development Certification: Java programming

Get ready for the exam

Dirk deRoos (dderoos_ibm@yahoo.ca), Technical Writer and Samples Developer, IBM

Dirk deRoos (BA, BCS) is a technical writer and samples developer on the DB2 Information Development team. He has recently coauthored The Official Guide to DB2 Version 8.1.2 (Prentice-Hall, 2003), and wrote chapters for DB2: The Complete Reference (Osborne/McGraw-Hill, 2001). Dirk specializes in database performance monitoring and DB2 application development. He is a DB2 Certified Solutions Expert (Application Development, Business Intelligence). You can reach Dirk by sending a message to dderoos_ibm at yahoo.ca.

Summary: In this tutorial, you'll learn about writing Java code that interfaces with DB2 Universal Database. This is the fifth in a series of seven tutorials that you can use to help prepare for the DB2 UDB V8.1 Family Application Development certification exam (Exam 703).

Date: 28 May 2002
Level: Introductory
PDF: A4 and Letter (86 KB | 25 pages)Get Adobe® Reader®

Activity: 4753 views
Comments:

Before you start

What is this tutorial about?

In this tutorial, you'll learn about writing Java code that interfaces with DB2 Universal Database. You'll see how to:

Connect to a DB2 database from a Java application
Use JDBC to read and update data in a DB2 database
Use SQLJ to read and update data in a DB2 database
Troubleshoot a DB2 Java application

This tutorial provides you with the fundamental skills required to develop Java applications for DB2.

This is the fifth in a series of seven tutorials that you can use to help prepare for the DB2 UDB V8.1 Family Application Development Certification exam (Exam 703). The material in this tutorial primarily covers the objectives in Section 5 of the exam, entitled "Java programming." You can view these objectives at: http://www.ibm.com/certify/tests/obj703.shtml.

You do not need a copy of DB2 Universal Database to complete this tutorial. However, you can download a free trial version of IBM DB2 Universal Database from the developerWorks downloads site for reference.

Who should take this tutorial?

To take the DB2 UDB V8.1 Family Application Development exam, you must have already passed the DB2 UDB V8.1 Family Fundamentals exam (Exam 700). You can use the DB2 Family Fundamentals tutorial series (see Resources) to prepare for that test. It is a very popular tutorial series that has helped many people understand the fundamentals of the DB2 family of products.

This tutorial is one of the tools that can help you prepare for Exam 703. You should also review Resources at the end of this tutorial for more information.

In addition to this DB2 background, you should also have basic knowledge of SQL and the Java platform before taking this tutorial.

System requirements

If you plan to develop Java applications for DB2, or you plan to try out this tutorial's sample code yourself, you need to complete the following tasks:

Install DB2 Universal Database, Version 8.1 for Linux, UNIX, or Windows.
Create the sample database by running db2sampl from the DB2 CLP. The sample code in this article has been written to work with this database.
Install the Java Runtime Environment, Java 2 Technology Edition, Version 1.3.1.
Update the PATH environment variable to include the jdk\bin directory of the Java SDK you have installed. Note that DB2 includes Java SDK, version 1.3.1, in the $DB2PATH\sqllib\java\jdk\bin directory ($DB2PATH/sqllib/java/jdk/bin in UNIX).

Notices and trademarks

IBM, DB2, DB2 Universal Database, DB2 Information Integrator, WebSphere and WebSphere MQ are trademarks or registered trademarks of IBM Corporation in the United States, other countries, or both.

Other company, product, and service names may be trademarks or service marks of others.

Comments