thanks, I am using 7.1 too, I did download the new one and it doesn't help. I am going to try this:
http://marc.theaimsgroup.com/?l=tomcat-user&m=102225547106556&w=2 the new pooling may be more robust anyway.... clay -----Original Message----- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 5:44 AM To: Struts Users Mailing List Subject: RE: datasource classpath issue with MySQL driver I've had this problem as well, even after I unzipped the jar file. I put it out on the list twice and never got much response. You can try different versions of the driver, but there is something buggy with the MySQL driver and Struts. I was on RH 7.1 Steve "Jesse Alexander (KADA 11)" To: Struts Users Mailing List <[EMAIL PROTECTED]> <alexander.jesse cc: @csfs.com> Subject: RE: datasource classpath issue with MySQL driver 07/02/2002 01:44 AM Please respond to "Struts Users Mailing List" Hi, at some time I had problems with MySQl-driver when I used the compressed jar-file. Try to use the uncompressed jar-file. hope this helps Alexander -----Original Message----- From: matt_raible [mailto:[EMAIL PROTECTED]] Sent: Montag, 1. Juli 2002 06:08 To: [EMAIL PROTECTED] Subject: Re: datasource classpath issue with MySQL driver 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 [EMAIL PROTECTED], Clay Graham <[EMAIL PROTECTED]> 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: <mailto:struts-user-unsubscribe@j...> > For additional commands, e-mail: <mailto:struts-user-help@j...> -- To unsubscribe, e-mail: < mailto:[EMAIL PROTECTED]> For additional commands, e-mail: < mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: < mailto:[EMAIL PROTECTED]> For additional commands, e-mail: < mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
