ClassNotFoundException: com.mysql.jdbc.Driver

[Hector Pertierra]

Hi everybody

I have a BIG problem with my ANT buildfile. I'm trying to run a simple Test to connect to my app's database, but after it succesfully COMPILES and JARS itself, when it gets to EXECUTE I get the following message:

[java] org.dotcom.contab.proceso.DAOException: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
[java] at org.dotcom.contab.proceso.impl.MySQLDAOFactory.<init>(Unknown Source)
[java] at org.dotcom.contab.proceso.DAOFactory.getDAOFactory(Unknown Source)
[java] at org.dotcom.contab.salida.Main.main(Unknown Source)
[java] Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
[java] at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
[java] at java.security.AccessController.doPrivileged(Native Method)
[java] at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
[java] at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
[java] at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
[java] at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
[java] at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
[java] at java.lang.Class.forName0(Native Method)
[java] at java.lang.Class.forName(Class.java:164)
[java] at org.dotcom.contab.proceso.impl.MySQLDAOFactory.loadDriver(Unknown Source)


I know I probably have a problem with the CLASSPATH, since I'm running the app directly from the jar archive: here's the code:

    
 
--Laboratorio1
---lib
====mysql-connector-java-3.1.7-bin.jar
---src
---dist
====Laboratorio1.jar
---build
---doc
 
<path id="compile.classpath">
<pathelement path="${java.class.path}"/>
      <fileset dir="lib">
        <include name="**/*.jar"/>
      </fileset>
         </path>
 
    <target name="compile">
<javacdestdir="./build"
srcdir="./src">
<classpath refid="compile.classpath" />
<include name="**/*.java" />
</javac>
<echo>Compilacion terminada...</echo>            
    </target>

<target name="archive" depends="compile">
    <manifest file="MANIFEST.MF">
    <attribute name="Main-Class" value="org.dotcom.contab.salida.Main"/>
    <attribute name="Class-Path" value="lib/mysql-connector-java-3.1.7-bin.jar" />
    </manifest>
<jar destfile="./dist/Laboratorio1.jar"
manifest="MANIFEST.MF">
<fileset dir="./build" />
<fileset dir="." includes="lib/*.jar" />
</jar>
</target>

    
Manifest-Version: 1.0
Ant-Version: Apache Ant 1.6.2
Created-By: 1.5.0_06-61 ("Apple Computer, Inc.")
Main-Class: org.dotcom.contab.salida.Main
Class-Path: lib/mysql-connector-java-3.1.7-bin.jar

I'm really really stuck, I've tried a bunch of things and I don't know what to do anymore. I read somewhere that when running a program from the jar it ignores user classpath settings, is it true??? I NEED to run it from the jar since it's one of the projects requirements...

PLEASE HELP!!!

Thanks in advance
Hector

[Ilja Preuss]

I notice that you seem to be putting third party jars into your jar file. Those other jars will *not* automatically be on the classpath!

[Hector Pertierra]

Yeah, I'm aware of that, but how do I PUT them into the classpath???

[Hector Pertierra]

After fighting with the CLASSPATH for more than 24 hours, I fixed it

I had to put the JAR File next to the distribution. And set the Manifest's Class-Path to the JAR File. It finally worked. Thanks!

[prateek urmaliya]

May be It's too late
but you can try

    
<?xml version="1.0" encoding="UTF-8"?>
 
<project default="jar" name="cheburashka" basedir=".">
 
<property file="build.properties" />
 
<echo>project.name=${ant.project.name}</echo>
 
<target name="clean"
description="Clean up the generated directories">
<delete dir="${classes.dir}"/>
</target>
 

<target name="init" description="" depends="clean">
        <mkdir dir="${classes.dir}" />
</target>
 

<path id="project.class.path">
<fileset dir="${lib.dir}" includes="*.jar" />
</path>
 

<target name="compile" description="Compile the code"
depends="init">
<javac destdir="${classes.dir}" deprecation="true" source="1.4"
debug="on">
<src>
<pathelement location="${src.dir}" />
</src>
<classpath refid="project.class.path" />
</javac>
<copy todir="${classes.dir}" Overwrite="Yes">
<fileset dir="${src.dir}">
<include name="conf/**" />
</fileset>
</copy>
</target>
 
<target name="jar" description="Create a executable jar"
depends="compile">
<pathconvert dirsep="/" pathsep=" " property="project.class.path">
<map from="${basedir}/${lib.dir}/" to="" />
<map from="${basedir}\${lib.dir}\" to="" />
<path>
<fileset dir="${lib.dir}">
<include name="*.jar" />
</fileset>
</path>
</pathconvert>
<echo message="Creating jar ..." />
<jar destfile="${lib.dir}/${dist.name}-${dist.version}.jar"
 >
<fileset dir="${classes.dir}">
<exclude name="conf/**" />
</fileset>
<manifest>
<attribute name="Manifest-Version" value="${manifest.version}"/>
<attribute name="Built-By" value="${user.name}"/>
<attribute name="Main-Class" value="${main.class}"/>
<attribute name="Class-Path" value="${project.class.path}"/>
</manifest>
</jar>
</target>
 
</project>