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

[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]