RE: Tomcat DB2 JDBC issue

2007-11-16 Thread Caldarale, Charles R
> From: Andrew R Feller [mailto:[EMAIL PROTECTED] > Subject: RE: Tomcat DB2 JDBC issue > > Hr, the -cp command-line parameter will include the JARs within > Tomcat's System classloader, correct? Slight terminology correction: strictly speaking, it's the JVM&

Re: Tomcat DB2 JDBC issue

2007-11-16 Thread Gregor Schneider
Hi Andrew, that's why I suggest that you define a data-pool in your application-specific context.xml-file (stred in config/server) and put all the needed JDBC-drivers to $CATALINA_HOME/common/lib With this scenario, no web-app need to provide their JDBC-drivers in the WEB-INF/lib-directories and

RE: Tomcat DB2 JDBC issue

2007-11-16 Thread Andrew R Feller
etc. Andrew R Feller, Analyst Subversion Administrator University Information Systems Louisiana State University [EMAIL PROTECTED] (office) 225.578.3737 -Original Message- From: Caldarale, Charles R [mailto:[EMAIL PROTECTED] Sent: Thursday, November 15, 2007 3:44 PM To: Tomcat Users List

Re: Tomcat DB2 JDBC issue

2007-11-16 Thread Gregor Schneider
Hi Andrew, I've just checked the DB2-JDBC-Drivers: You'll need two files: 1. db2jcc_license_cu.jar 2. db2jcc.jar Both files should be somewhere on your copy of DB2 or you should be able to download them via the IBM-website. If you're running Db2 on OS390/zOS, you'll need a certain APAR first -

RE: Tomcat DB2 JDBC issue

2007-11-16 Thread Andrew R Feller
er 16, 2007 9:43 AM To: Tomcat Users List Subject: Re: Tomcat DB2 JDBC issue Hi Andrew, I've just checked the DB2-JDBC-Drivers: You'll need two files: 1. db2jcc_license_cu.jar 2. db2jcc.jar Both files should be somewhere on your copy of DB2 or you should be able to download them via the

Re: Tomcat DB2 JDBC issue

2007-11-16 Thread Gregor Schneider
It's quite some time since my last experience with DB2, however, maybe this gives you a start: There are multiple jdbc-drivers available for DB2. Obviously, youÄre using a class3-JDBC-driver, meaning that this is not a plain java-driver but needs some middleware to connect to DB2 (DB2-Connect).

RE: Tomcat DB2 JDBC issue

2007-11-15 Thread Caldarale, Charles R
> From: Andrew R Feller [mailto:[EMAIL PROTECTED] > Subject: RE: Tomcat DB2 JDBC issue > > With all of this grief developing a LoginModule that is used > invoked on a Context basis, I have noticed there are lots of > issues with classes loaded by the server/common cla

RE: Tomcat DB2 JDBC issue

2007-11-15 Thread Andrew R Feller
PROTECTED] Sent: Thursday, November 15, 2007 12:59 PM To: Tomcat Users List Subject: RE: Tomcat DB2 JDBC issue Hey Chuck, We had the same idea about the java.library.path property, too. After more fiddling around, I think we figured out what is going on. 1st: Set JAVA_OPTS to include

RE: Tomcat DB2 JDBC issue

2007-11-15 Thread Andrew R Feller
nformation Systems Louisiana State University [EMAIL PROTECTED] (office) 225.578.3737 -Original Message- From: Caldarale, Charles R [mailto:[EMAIL PROTECTED] Sent: Thursday, November 15, 2007 11:22 AM To: Tomcat Users List Subject: RE: Tomcat DB2 JDBC issue > From: Andrew R Feller [

RE: Tomcat DB2 JDBC issue

2007-11-15 Thread Caldarale, Charles R
> From: Andrew R Feller [mailto:[EMAIL PROTECTED] > Subject: RE: Tomcat DB2 JDBC issue > > By blanking out the environment variable for PATH and > restarting Tomcat, the application, which was being > initialized successfully, now fails in the same way > Tomcat was fail

RE: Tomcat DB2 JDBC issue

2007-11-15 Thread Andrew R Feller
PROTECTED] Sent: Thursday, November 15, 2007 9:19 AM To: Tomcat Users List Subject: RE: Tomcat DB2 JDBC issue > From: Andrew R Feller [mailto:[EMAIL PROTECTED] > Subject: RE: Tomcat DB2 JDBC issue > > The question now is why Tomcat cannot use the driver if it is in the > "common

RE: Tomcat DB2 JDBC issue

2007-11-15 Thread Andrew R Feller
8:40 AM To: Tomcat Users List Subject: Re: Tomcat DB2 JDBC issue Hi Andrew- Apparently the driver is only available thru WAS http://www-1.ibm.com/support/docview.wss?uid=swg21201371 or DB2-Client http://www-306.ibm.com/software/data/db2/support/db2_9/ Anyone else? M-- - Origin

RE: Tomcat DB2 JDBC issue

2007-11-15 Thread Andrew R Feller
-Original Message- From: Caldarale, Charles R [mailto:[EMAIL PROTECTED] Sent: Thursday, November 15, 2007 9:19 AM To: Tomcat Users List Subject: RE: Tomcat DB2 JDBC issue > From: Andrew R Feller [mailto:[EMAIL PROTECTED] > Subject: RE: Tomcat DB2 JDBC issue > > The questio

RE: Tomcat DB2 JDBC issue

2007-11-15 Thread Caldarale, Charles R
> From: Andrew R Feller [mailto:[EMAIL PROTECTED] > Subject: RE: Tomcat DB2 JDBC issue > > The question now is why Tomcat cannot use the driver if it is in the > "common" directory? By any chance, are you running with a SecurityManager? Any access permission issues

RE: Tomcat DB2 JDBC issue

2007-11-15 Thread Andrew R Feller
Users List Subject: Re: Tomcat DB2 JDBC issue Hi Andrew- Apparently the driver is only available thru WAS http://www-1.ibm.com/support/docview.wss?uid=swg21201371 or DB2-Client http://www-306.ibm.com/software/data/db2/support/db2_9/ Anyone else? M-- - Original Message

Re: Tomcat DB2 JDBC issue

2007-11-15 Thread Martin Gainty
> To: "Tomcat Users List" Sent: Thursday, November 15, 2007 8:50 AM Subject: Tomcat DB2 JDBC issue Database: DB2 v7 OS390 Server: DB2 Connect v9, Tomcat 6.0.14, Java 1.6 Issue: LoginModule unable to load driver; raises SQLException "No suitable driver found" Connection Strin

Tomcat DB2 JDBC issue

2007-11-15 Thread Andrew R Feller
Database: DB2 v7 OS390 Server: DB2 Connect v9, Tomcat 6.0.14, Java 1.6 Issue: LoginModule unable to load driver; raises SQLException "No suitable driver found" Connection String: jdbc:db2:blah Driver: COM.ibm.db2.jdbc.app.DB2Driver I am developing a custom JAAS LoginModule to go against a data