With Tomcat 4 or 5, with JDK 1.4, I cannot load my JDBC drive from a *.jar
in shared\lib, unless that driver has already been loaded by a webapp class
using Class.forName(). I normally use the system property
jdbc.drivers=xxx mechanism to allow java.sql.DriverManager to load the
driver. For
LOGINroot/LOGIN
PASSWORD/PASSWORD
ive tried it under tomcat 4 and 5 both were working perfectly
[EMAIL PROTECTED]
administrateur http://entre-nous.qc.tc
mandrake 9.1 running and connected
From: [EMAIL PROTECTED]
Reply-To: Tomcat Users List [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Loading JDBC
Why does the following work:
Class.forName(com.mysql.jdbc.Driver).newInstance();
Connection conn =
DriverManager.getConnection(jdbc:mysql://10.117.7.18:3306/dow?autoReconnect=true,
user, pwd);
PreparedStatement t_stm =
conn.prepareStatement(select name from templates);
ResultSet t_rs =
is your mysql jar file in /common/lib instead of in /WEB-INF/lib?
Charlie
-Original Message-
From: Paul Tomsic [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 17, 2002 3:37 PM
To: [EMAIL PROTECTED]
Subject: loading jdbc driver fails from DataSource and Context -
classLoader
yes.
% cd /usr/local/tomcat/common/lib
% ls -la
-rw-r--r-- 1 tomsicp staff 45386 Oct 30 19:38
activation.jar
-rw-r--r-- 1 tomsicp staff 716139 Oct 30 19:38
ant.jar
-rw-r--r-- 1 tomsicp staff 90503 Oct 30 19:38
commons-collections.jar
-rw-r--r-- 1 tomsicp staff 62998 Oct 30
- Original Message -
From: Sean Reilly [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Wednesday, October 23, 2002 10:11 PM
Subject: RE: Loading jdbc driver
by the all caps in CLASSPATH, I assume that you mean the CLASSPATH
environment variable.
Try putting the classes/jar in the WEB
, October 24, 2002 10:33 AM
Subject: Re: Loading jdbc driver
Thanks for the idea Sean. I tried putting the jar file under my
WEB-INF\lib
directory but get the same error.
If I then try to delete this file with TC running I can't because TC has
locked it, so this would indicate that TC thinks it found
Message-
From: Andy Wickson [mailto:andy;awtech.co.uk]
Sent: Wednesday, October 23, 2002 9:21 AM
To: Tomcat Users List
Subject: Loading jdbc driver
Hi,
I am attempting to access a Cloudscape DB.
The driver is com.ibm.db2j.jdbc.DB2jDriver and this class is present in the relevant
jar file
I am using tomcat 4 and I am having problems loading the jdbc driver as
follows:
java.lang.ClassNotFoundException: com.informix.jdbc.IfxDriver whenever I
try to load the servlet thru the web browser.
However, if I run the jdbc loading through standalone java program, it loads
fine and executes
: loading jdbc driver
I am using tomcat 4 and I am having problems loading the jdbc driver as
follows:
java.lang.ClassNotFoundException: com.informix.jdbc.IfxDriver whenever
I
try to load the servlet thru the web browser.
However, if I run the jdbc loading through standalone java program
Standalone jave works, but the servlet doesn't? Sounds like either the file
isn't in the right place ( $CATALINA_BASE/common/lib, $CATALINA_BASE/lib, or
WEB-INF/lib ) or it's named as a .zip instead of .jar. Tomcat only looks for
.jar files (.zip files are ignored) in one of the above listed
-Original Message-
From: Alfar, Adam [mailto:[EMAIL PROTECTED]]
Sent: January 11, 2002 1:14 PM
To: '[EMAIL PROTECTED]'
Subject: loading jdbc driver
I am using tomcat 4 and I am having problems loading the jdbc driver as
follows:
java.lang.ClassNotFoundException
Thanks Praven and ALL Tomcat users for the advice! IT WORKED!! GOOD WEEKEND
EVERYBODY :-)
-Original Message-
From: Praveen Potineni [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 12:59 PM
To: Tomcat Users List
Subject: Re: loading jdbc driver
Adam,
Put the driver files
I added a symlink to it in the $CATALINA_BASE/lib directory and that did
it...thanks guys!
-Original Message-
From: David Smith [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 1:32 PM
To: Tomcat Users List
Subject: Re: loading jdbc driver
Standalone jave works
14 matches
Mail list logo