Notes/Problems Installing & Using IBM's DB2 v8.1 on my Laptop   12-15-2005

Problem:  Can't use the Type 4 JDBC DB2 Driver.

   Their samples (in C:\Program Files\IBM\SQLLIB\samples\java\jdbc, which I copied
to C:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps\db2.samples.jdbc)

has DbConn.java, which simply connects to the "sample" database.  Calling it with
no arguments, e.g. just  java DbConn, gives you

THIS SAMPLE SHOWS HOW TO CONNECT TO/DISCONNECT FROM DATABASES.

----------------------------------------------------------
USE JAVA 2 CLASSES:
  Connection
  DriverManager
TO CONNECT TO/DISCONNECT FROM A DATABASE.
  Connect to 'sample' database using JDBC type 2 driver.
      url=>jdbc:db2:sample<                <--- I added this line for me.

Using DriverManger.getConnection(url,,) form   <--- And this line, too.


  Disconnect from 'sample' database.


This uses the Db class from the Util.java file (so I had to compile this first --
why didn't it tell me this?), and in that class, is the real database-connect
code.  Looking at it and the DbConn.java file, you can invoke DbConn with
arguments that will get passed to the Db class and used in the connect-to-DB2
call.  However, I get the following error message:
    java DbConn localhost 50000 jasper newyear6; (my password at the time)

THIS SAMPLE SHOWS HOW TO CONNECT TO/DISCONNECT FROM DATABASES.

----------------------------------------------------------
USE JAVA 2 CLASSES:
  Connection
  DriverManager
TO CONNECT TO/DISCONNECT FROM A DATABASE.
  Connect to 'sample' database using JDBC type 4 driver.   <--- Note not type 2
      url=>jdbc:db2://localhost:50000/sample<

Using DriverManger.getConnection(url,jasper,newyear6;) form  <--- And different here

Expired JDBC driver.  IBM DB2 JDBC Universal Driver Architecture 1.2.34 Test Bui
ld expired on Sun Jun 01 00:00:00 PDT 2003