Hi,

I am trying to make a UBD DB2 7.2 connection using the Java
COM.ibm.db2.jdbc.app.DB2Driver via Tomcat 3.2.1 on Solaris (and also
on an AIX system with 3.3.1).   I am attempting this either via JSP or
a servlet.

I have a separate java application that I can run from the command
line and as long as the user has the correct env variables:

DB2DIR=/opt/IBMdb2/V7.1
DB2INSTANCE=repowner
INSTHOME=/home/repowner

Then the connection is fine.  I am using the same code to try and make
the connection via tomcat.

  try
   {
       Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
       //      next line is printed out
       System.out.println(new java.util.Date().toString() + " DRIVER
FOUND.");
   }
   catch(ClassNotFoundException e)
    {
       System.out.println(new java.util.Date().toString() + " Error 1:
"+e);
    }
   String dbType="db2";
//    String ip="10.0.0.185";
//    String port="8790";
   String dbName="ppreport";
   String reason="testing db connection";
   String userName="repowner";
   String password="ilink1";
   Connection con = null;
   
   String url = "jdbc:db2:"+dbName;
   
   boolean dbConnected = false;
   
   try
    {
       System.out.println(new java.util.Date().toString() + " Connecting
to database URL = " + url + " for " + reason);
      
      
       Enumeration e = DriverManager.getDrivers();
       while (e.hasMoreElements()) {
           Driver d = (Driver) e.nextElement();
           //         doesn't print anything here
           System.out.println("driver is " + d.toString());
       }
       System.out.println("a1");
       //        gets to here and stops!  
       Driver d = DriverManager.getDriver(url);
       System.out.println("a1.1"+d.toString());
      
       con = DriverManager.getConnection(url, userName, password);
      
       java.sql.Statement stmt = con.createStatement();
       System.out.println("SETTING SCHEMA TO "+dbName);
       try {
           stmt.execute("SET SCHEMA = "+dbName);
           System.out.println("SCHEMA SET.");
       }
       catch (Exception ex) {
           System.out.println("Error Setting Schema:"+ex);
       }
      
       System.out.println(new java.util.Date().toString() + " Database
connection established.XX");
       dbConnected = true;
    }
   catch(Exception e)
    {
       System.out.println(new java.util.Date().toString() + " Failed to
connect, reason : \n" + e);
      
    }

However via tomcat the driver cannot be loaded by the class loader.
The class is found, but not loaded.  The error I receive is
"java.sql.SQLException: No suitable driver"

I have placed the db2java.zip (renamed as db2java.jar) in several
places to try and solve the problem (restarting Tomcat each time) but
to no avail:

/usr/apache/tomcat/common/lib/db2java.jar
.../WEB-INF/classes/db2java.jar

I have read many posts, but I can't understand how the driver will
know the correct env variables even if the class is loaded.

Any help would be much appreciated!!!

Thanks!
Andy.