You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by Clay Graham <cl...@newobjectivity.com> on 2002/07/01 01:38:05 UTC
datasource classpath issue with MySQL driver
Hello STRUTS Users,
I am asking a question because I am very suprised at an unexepected
behaviour and thought that someone may have a hint.
I have tomcat 404 ant struts 102 working and they have been tested, and I
am taking the next step by starting to connect to my MySql database, all
goodness.
So my first step was to add the datasource in my struts-config.xml as
follows:
<data-sources>
<data-source>
<set-property property="autoCommit"
value="false"/>
<set-property property="description"
value="The Test Datasource"/>
<set-property property="driverClass"
value="org.gjt.mm.mysql.Driver"/>
<set-property property="maxCount"
value="4"/>
<set-property property="minCount"
value="2"/>
<set-property property="password"
value=""/>
<set-property property="url"
value="jdbc:mysql://localhost/test"/>
<set-property property="user"
value="root"/>
</data-source>
</data-sources>
the next step was to add the mm.mysql-2.0.6.1.jar to my project's
WEB-INF/lib directory, the standard approach....
[clay@meis test]$ jar -tvf test.war|grep mm.mysql
390333 Sun Jun 30 16:20:20 PDT 2002 WEB-INF/lib/mm.mysql-2.0.6.1.jar
I am sure this JAR has the mysql driver in it:
[clay@meis test]$ jar -tvf web/WEB-INF/lib/mm.mysql-2.0.6.1.jar |grep
Driver
15163 Sat Jun 16 09:20:28 PDT 2001
mm.mysql-2.0.6/org/gjt/mm/mysql/Driver.java
5443 Sat Jun 16 09:20:28 PDT 2001
mm.mysql-2.0.6/org/gjt/mm/mysql/Driver.class
so when I install the application using ant the following error occurs:
----- Root Cause -----
java.sql.SQLException: open: java.lang.ClassNotFoundException:
org.gjt.mm.mysql.Driver
I have even put mm.mysql-2.0.6.1.jar in tomcat/common/lib and it does not
find the driver. I am asking this question on this list because it happens
in struts-config.xml
any ideas & help is appreciated!
clay
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: datasource classpath issue with MySQL driver
Posted by matt_raible <ma...@yahoo.com>.
You might want to try a newer version of the MySQL JDBC Driver. I'm
using 2.0.14 and it works fine in Tomcat. Also, I register it with
Tomcat via JNDI (server.xml) and then look it up in my classes.
HTH,
Matt
--- In struts@y..., Clay Graham <cl...@n...> wrote:
> Hello STRUTS Users,
>
> I am asking a question because I am very suprised at an
unexepected
> behaviour and thought that someone may have a hint.
>
> I have tomcat 404 ant struts 102 working and they have been
tested, and I
> am taking the next step by starting to connect to my MySql
database, all
> goodness.
>
> So my first step was to add the datasource in my struts-config.xml
as
> follows:
>
> <data-sources>
> <data-source>
> <set-property property="autoCommit"
> value="false"/>
> <set-property property="description"
> value="The Test Datasource"/>
> <set-property property="driverClass"
> value="org.gjt.mm.mysql.Driver"/>
> <set-property property="maxCount"
> value="4"/>
> <set-property property="minCount"
> value="2"/>
> <set-property property="password"
> value=""/>
> <set-property property="url"
> value="jdbc:mysql://localhost/test"/>
> <set-property property="user"
> value="root"/>
> </data-source>
> </data-sources>
>
> the next step was to add the mm.mysql-2.0.6.1.jar to my project's
> WEB-INF/lib directory, the standard approach....
>
> [clay@meis test]$ jar -tvf test.war|grep mm.mysql
> 390333 Sun Jun 30 16:20:20 PDT 2002 WEB-INF/lib/mm.mysql-
2.0.6.1.jar
>
> I am sure this JAR has the mysql driver in it:
>
> [clay@meis test]$ jar -tvf web/WEB-INF/lib/mm.mysql-2.0.6.1.jar
|grep
> Driver
> 15163 Sat Jun 16 09:20:28 PDT 2001
> mm.mysql-2.0.6/org/gjt/mm/mysql/Driver.java
> 5443 Sat Jun 16 09:20:28 PDT 2001
> mm.mysql-2.0.6/org/gjt/mm/mysql/Driver.class
>
> so when I install the application using ant the following error
occurs:
>
> ----- Root Cause -----
> java.sql.SQLException: open: java.lang.ClassNotFoundException:
> org.gjt.mm.mysql.Driver
>
> I have even put mm.mysql-2.0.6.1.jar in tomcat/common/lib and it
does not
> find the driver. I am asking this question on this list because it
happens
> in struts-config.xml
>
> any ideas & help is appreciated!
>
> clay
>
>
>
>
> --
> To unsubscribe, e-mail: <ma...@j...>
> For additional commands, e-mail: <ma...@j...>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>