Tomcat DB2 connection - No suitable driver

[Andrew Johnson]

Hi,

I am trying to make a UBD DB2 7.2 connection using the Java
COM.ibm.db2.jdb c.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=rep owner
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.jdb c.app.DB2Driver ");
// next line is printed out
System.out.prin tln(new java.util.Date( ).toString() + " DRIVER
FOUND.");
}
catch(ClassNotF oundException e)
{
System.out.prin tln(new java.util.Date( ).toString() + " Error 1:
"+e);
}
String dbType="db2";
// String ip="10.0.0.185" ;
// String port="8790";
String dbName="pprepor t";
String reason="testing db connection";
String userName="repow ner";
String password="ilink 1";
Connection con = null;

String url = "jdbc:db2:"+dbN ame;

boolean dbConnected = false;

try
{
System.out.prin tln(new java.util.Date( ).toString() + " Connecting
to database URL = " + url + " for " + reason);
Enumeration e = DriverManager.g etDrivers();
while (e.hasMoreEleme nts()) {
Driver d = (Driver) e.nextElement() ;
// doesn't print anything here
System.out.prin tln("driver is " + d.toString());
}
System.out.prin tln("a1");
// gets to here and stops!
Driver d = DriverManager.g etDriver(url);
System.out.prin tln("a1.1"+d.to String());

con = DriverManager.g etConnection(ur l, userName, password);

java.sql.Statem ent stmt = con.createState ment();
System.out.prin tln("SETTING SCHEMA TO "+dbName);
try {
stmt.execute("S ET SCHEMA = "+dbName);
System.out.prin tln("SCHEMA SET.");
}
catch (Exception ex) {
System.out.prin tln("Error Setting Schema:"+ex);
}

System.out.prin tln(new java.util.Date( ).toString() + " Database
connection established.XX" );
dbConnected = true;
}
catch(Exception e)
{
System.out.prin tln(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.SQLEx ception: 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.

[amurchis]

The attempted connection will throw the error you are seeing if the
class has not been loaded first. The most common source of this is if
the driver class you specified is not found in your CLASSPATH. On
issuing the Class.forName() call, the java classloader will search the
CLASSPATH for a class with the given name, and load it into memory. An
exception is not thrown here unless you try to create a newInstance() of
the class.

Thus, you'll need to modify your CLASSPATH to include the location of
the DB2 Java drivers.

Andrew Johnson wrote:

Hi,

I am trying to make a UBD DB2 7.2 connection using the Java
COM.ibm.db2.jdb c.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=rep owner
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.jdb c.app.DB2Driver ");
// next line is printed out
System.out.prin tln(new java.util.Date( ).toString() + " DRIVER
FOUND.");
}
catch(ClassNotF oundException e)
{
System.out.prin tln(new java.util.Date( ).toString() + " Error 1:
"+e);
}
String dbType="db2";
// String ip="10.0.0.185" ;
// String port="8790";
String dbName="pprepor t";
String reason="testing db connection";
String userName="repow ner";
String password="ilink 1";
Connection con = null;

String url = "jdbc:db2:"+dbN ame;

boolean dbConnected = false;

try
{
System.out.prin tln(new java.util.Date( ).toString() + " Connecting
to database URL = " + url + " for " + reason);
Enumeration e = DriverManager.g etDrivers();
while (e.hasMoreEleme nts()) {
Driver d = (Driver) e.nextElement() ;
// doesn't print anything here
System.out.prin tln("driver is " + d.toString());
}
System.out.prin tln("a1");
// gets to here and stops!
Driver d = DriverManager.g etDriver(url);
System.out.prin tln("a1.1"+d.to String());

con = DriverManager.g etConnection(ur l, userName, password);

java.sql.Statem ent stmt = con.createState ment();
System.out.prin tln("SETTING SCHEMA TO "+dbName);
try {
stmt.execute("S ET SCHEMA = "+dbName);
System.out.prin tln("SCHEMA SET.");
}
catch (Exception ex) {
System.out.prin tln("Error Setting Schema:"+ex);
}

System.out.prin tln(new java.util.Date( ).toString() + " Database
connection established.XX" );
dbConnected = true;
}
catch(Exception e)
{
System.out.prin tln(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.SQLEx ception: 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.

[amurchis]

I mean to say "... if the driver class has not been loaded first" in the
first sentence.

Andrew Johnson wrote:

Hi,

I am trying to make a UBD DB2 7.2 connection using the Java
COM.ibm.db2.jdb c.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=rep owner
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.jdb c.app.DB2Driver ");
// next line is printed out
System.out.prin tln(new java.util.Date( ).toString() + " DRIVER
FOUND.");
}
catch(ClassNotF oundException e)
{
System.out.prin tln(new java.util.Date( ).toString() + " Error 1:
"+e);
}
String dbType="db2";
// String ip="10.0.0.185" ;
// String port="8790";
String dbName="pprepor t";
String reason="testing db connection";
String userName="repow ner";
String password="ilink 1";
Connection con = null;

String url = "jdbc:db2:"+dbN ame;

boolean dbConnected = false;

try
{
System.out.prin tln(new java.util.Date( ).toString() + " Connecting
to database URL = " + url + " for " + reason);
Enumeration e = DriverManager.g etDrivers();
while (e.hasMoreEleme nts()) {
Driver d = (Driver) e.nextElement() ;
// doesn't print anything here
System.out.prin tln("driver is " + d.toString());
}
System.out.prin tln("a1");
// gets to here and stops!
Driver d = DriverManager.g etDriver(url);
System.out.prin tln("a1.1"+d.to String());

con = DriverManager.g etConnection(ur l, userName, password);

java.sql.Statem ent stmt = con.createState ment();
System.out.prin tln("SETTING SCHEMA TO "+dbName);
try {
stmt.execute("S ET SCHEMA = "+dbName);
System.out.prin tln("SCHEMA SET.");
}
catch (Exception ex) {
System.out.prin tln("Error Setting Schema:"+ex);
}

System.out.prin tln(new java.util.Date( ).toString() + " Database
connection established.XX" );
dbConnected = true;
}
catch(Exception e)
{
System.out.prin tln(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.SQLEx ception: 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.

[Alex Kizub]

Actually this message means that your database url
String url = "jdbc:db2:"+dbN ame;
does not match all already loaded drivers.
That's all.
In other words your driver COM.ibm.db2.jdb c.app.DB2Driver does not
recognize url
"jdbc:db2:pprep ort"

I don't like IBM for their documentation. It took a year for me to
understand what they want when I tried to connect to DB2 on mainframe. So,
I really don't know what your driver wants. Try documnetation or examples
(if you have them :)))

How do you connect to your database wothout java? DB2 Connect? Local
instance?

Try another ways like this:
"jdbc:inetdb2:1 27.0.0.1:50000? database=pprepo rt",
//"jdbc:db2://127.0.0.1:50000/ppreport",
//"jdbc:db2:127.0 .0.1:50000:ppre port",
//"jdbc:db2:pprep ort",
Alex Kizub.

Andrew Johnson wrote:

Hi,

I am trying to make a UBD DB2 7.2 connection using the Java
COM.ibm.db2.jdb c.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=rep owner
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.jdb c.app.DB2Driver ");
// next line is printed out
System.out.prin tln(new java.util.Date( ).toString() + " DRIVER
FOUND.");
}
catch(ClassNotF oundException e)
{
System.out.prin tln(new java.util.Date( ).toString() + " Error 1:
"+e);
}
String dbType="db2";
// String ip="10.0.0.185" ;
// String port="8790";
String dbName="pprepor t";
String reason="testing db connection";
String userName="repow ner";
String password="ilink 1";
Connection con = null;

String url = "jdbc:db2:"+dbN ame;

boolean dbConnected = false;

try
{
System.out.prin tln(new java.util.Date( ).toString() + " Connecting
to database URL = " + url + " for " + reason);
Enumeration e = DriverManager.g etDrivers();
while (e.hasMoreEleme nts()) {
Driver d = (Driver) e.nextElement() ;
// doesn't print anything here
System.out.prin tln("driver is " + d.toString());
}
System.out.prin tln("a1");
// gets to here and stops!
Driver d = DriverManager.g etDriver(url);
System.out.prin tln("a1.1"+d.to String());

con = DriverManager.g etConnection(ur l, userName, password);

java.sql.Statem ent stmt = con.createState ment();
System.out.prin tln("SETTING SCHEMA TO "+dbName);
try {
stmt.execute("S ET SCHEMA = "+dbName);
System.out.prin tln("SCHEMA SET.");
}
catch (Exception ex) {
System.out.prin tln("Error Setting Schema:"+ex);
}

System.out.prin tln(new java.util.Date( ).toString() + " Database
connection established.XX" );
dbConnected = true;
}
catch(Exception e)
{
System.out.prin tln(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.SQLEx ception: 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.