Online Documentation
for Software Used in Projects 2 and 3

DB2 Downloads and Documentation for Projects 2 and 3

Stony Brook-specific DB2 connection information.

Free sign up is required for some of the links below.

• DB2 Express Server. This is needed if you want to set up a database on your own machine.
• DB2 Client. You would need it to connect to DB2 remotely.
• Data studio. Look under "Get free tools." See Using Data Studio to learn how to work with Data Studio. You can use it to browse DB2 through a graphical interface.
• DB2 University Training courses.
• DB2 9r7 Database Reference. Click on Database Reference in the left frame, then SQL, then Statements. For user-defined data types (UDTs), see CREATE TYPE (both row and structured).
  Also search for JDBC, especially JDBC samples.
  Explore the rest as needed.

Good on-line books. The first is very useful for Project 2, the second and third mostly for Project 3.

• DB2 Application Developer's Guide. Version 7. A bit outdated, but still useful. Chapter 12 is particularly useful for Project 2: deals with object-relational programming. The Java chapter (Chapter 21) is very goo, but be aware that it refers to an old JDBC driver, db2java. The right driver is db2jcc.
• Free book: The Developer Handbook. Java, XML, more. Most useful for Project 3: Chapter 2 (XML) and Chapter 5 (Java+XML).
• Also this one, for Project 3 . Especially Chapters 4, 5, 6.5(user-defined functions), 7.
• Free book: Getting started with DB2 Express. You will probably need only Chapter 15 for XQuery (Project 3). Also, Appendix A is useful for error codes.
• For more examples of using XQuery and JDBC, see also Listing 12 here and Example 1 here (ignore the CREATE PROCEDURE statement in the example: you do not need to create stored procedures).

Importing JDBC DB2 Driver into Eclipse

To use JDBC in your application, you must first download and install a DB2 JDBC driver, db2jcc.jar. You can find the instructions here.

Once downloaded, you must import the driver into Eclipse. If you are using an IDE other than Eclipse, check the documentation for that IDE. You might need to put the driver's folder in your CLASSPATH variable or import the driver analogously to how it is done in Eclipse.

To import db2jcc.jar, click on the Window menu in Eclipse and select Preferences. In the resulting dialog box, choose Java then Buid Path then User Libraries. Click on New and define a library name, e.g., DB2LIBS. Then click Add JARs, navigate to the folder that contains db2jcc.jar and add the driver to the library.

Also add db2jcc.jar to tomcat's lib folder to enable the servlet to access the database.

Tomcat

To run your application, you would need to install Tomcat on your machine. The easiest way to debug and run your application is to install the Eclipse Tomcat plugin.