Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'

2005-09-14 Thread luc_boudreau
Hi fellas,

I'm working on Tomcat 5.5.7 on a webapp compiled by Ant using shared and common 
libraries in their respective tomcat folders.

My mysql driver (mysql-connector-java-3.1.10-bin.jar) is in the 
$CATALINA_HOME/common/lib/ folder and I still get the following message :

Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'

It happens when the dataSourceVariable.getConnection() method of type 
org.apache.commons.dbcp.BasicDataSource is called in my program. 

The thing is, it works fine when I put all my libraries in the 
wabapp/application/WEB-INF/lib/ folder but I need to share (for production 
purposes) the mysql driver.

My Ant build.xml file includes the following directives, which include the 
libraries in a path variable :



path id=compile.classpath
pathelement location=${tomcat.home}/common/classes/
fileset dir=${tomcat.home}/common/endorsed
  include name=*.jar/
/fileset
fileset dir=${tomcat.home}/common/lib
  include name=*.jar/
/fileset
pathelement location=${tomcat.home}/shared/classes/
fileset dir=${tomcat.home}/shared/lib
  include name=*.jar/
/fileset
/path



And my compile target is as follows :



target name=compile depends=prepare
   description=Compiler les sources Java
mkdir dir=${build.home}/WEB-INF/classes/
javac srcdir=${src.dir}
  destdir=${build.dir}
debug=${compile.debug}
  deprecation=${compile.deprecation}
 optimize=${compile.optimize}
classpath refid=compile.classpath/
/javac
!-- Copy application resources --
copy  todir=${build.home}/WEB-INF/classes
fileset dir=${build.dir} excludes=**/*.java/
/copy
copy  todir=${build.home}/WEB-INF/
fileset 
dir=${basedir}/WEB-INF/ 
includes=**/*.xml, **/*.tld, **/*.dtd/
/copy
copy  todir=${build.home}/WEB-INF/lib
fileset dir=${basedir}/WEB-INF/lib includes=*.jar /
/copy
  /target


I've been working for over a week on this one and I'm out of ideas... if anyone 
has a flash, feel free to express it, who knows, it might help.



Luc Boudreau
SID - Université du Québec
[EMAIL PROTECTED]
 


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Re: Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'

2005-09-14 Thread David Delbecq
Just my 2 cents:

Have you tried putting it under shared/lib?

Also, are you sure it's a .jar and not a .zip extension for you file?

Am using here an oracle connector in various webapp. The driver is
under common/lib of tomcat 5.5.7 and i have no problems, so i bet this
is the right location Perhaps your file is corrupted (check you can unzip it and
the driver file exist in it).



Le Mercredi 14 Septembre 2005 17:01, [EMAIL PROTECTED] a écrit :
 Hi fellas,
 
 I'm working on Tomcat 5.5.7 on a webapp compiled by Ant using shared and 
 common libraries in their respective tomcat folders.
 
 My mysql driver (mysql-connector-java-3.1.10-bin.jar) is in the 
 $CATALINA_HOME/common/lib/ folder and I still get the following message :
 
 Cannot load JDBC driver class 'org.gjt.mm.mysql.Driver'
 
 It happens when the dataSourceVariable.getConnection() method of type 
 org.apache.commons.dbcp.BasicDataSource is called in my program. 
 
 The thing is, it works fine when I put all my libraries in the 
 wabapp/application/WEB-INF/lib/ folder but I need to share (for production 
 purposes) the mysql driver.
 
 My Ant build.xml file includes the following directives, which include the 
 libraries in a path variable :
 
 
 
 path id=compile.classpath
 pathelement location=${tomcat.home}/common/classes/
 fileset dir=${tomcat.home}/common/endorsed
   include name=*.jar/
 /fileset
 fileset dir=${tomcat.home}/common/lib
   include name=*.jar/
 /fileset
 pathelement location=${tomcat.home}/shared/classes/
 fileset dir=${tomcat.home}/shared/lib
   include name=*.jar/
 /fileset
 /path
 
 
 
 And my compile target is as follows :
 
 
 
 target name=compile depends=prepare
description=Compiler les sources Java
 mkdir dir=${build.home}/WEB-INF/classes/
 javac srcdir=${src.dir}
   destdir=${build.dir}
 debug=${compile.debug}
   deprecation=${compile.deprecation}
  optimize=${compile.optimize}
 classpath refid=compile.classpath/
 /javac
 !-- Copy application resources --
 copy  todir=${build.home}/WEB-INF/classes
   fileset dir=${build.dir} excludes=**/*.java/
 /copy
   copy  todir=${build.home}/WEB-INF/
   fileset 
   dir=${basedir}/WEB-INF/ 
   includes=**/*.xml, **/*.tld, **/*.dtd/
   /copy
   copy  todir=${build.home}/WEB-INF/lib
   fileset dir=${basedir}/WEB-INF/lib includes=*.jar /
 /copy
   /target
 
 
 I've been working for over a week on this one and I'm out of ideas... if 
 anyone has a flash, feel free to express it, who knows, it might help.
 
 
 
 Luc Boudreau
 SID - Université du Québec
 [EMAIL PROTECTED]
  
 
 
 -
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 
 

-- 
David Delbecq
Royal Meteorological Institute of Belgium

-
Is there life after /sbin/halt -p?

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]