Get DB2 Sample Java Application to Work

[elfinlaley]

Hi,

The code below is from the DB2 Java samples, and it is blowing up on the Class.forName("COM.ibm.... line. The package directory does not exist. Does anyone have a real life example of how this line should appear? I have the DB2 Enterprise version 7 installed on my Win2k box.

Thanks

class DB2Appl {

static {
try {
// register the driver with DriverManager

Class.forName("COM.ibm.db2.jdbc.app.DB2Driver"
} catch (Exception e) {
e.printStackTrace();
}
}

 

[elfinlaley]

Hi,

Solved my own problem after a pointer from a fellow programmer. With Win2k (as NT), you need the classpath for your User variables to include d:\sqllib\java\db2java.zip. This was already in the System environment variable. When I put the path in the User environment variable for the classpath, I was able to compile and get a result set.

Have a great day