I definitely new to all this stuff but i was able to successfully use
the driver........
here's what i did...
1.. Put mysql-connector-java-3.0.8-stable-bin.jar in
CATALINA_HOME\common\lib
2.. Didn't worry about setting the classpath for it...
3.. Server.xml stuff
<parameter>
<name>username</name>
<value>tomcat</value>
</parameter>
<parameter>
<name>password</name>
<value>sinner</value>
</parameter>
<!-- Class name for
MySQL jdbc driver-->
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<!--JDBC Connection
URL-->
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost/tomcatbook?autoReconnect=true</value>
</parameter>
</ResourceParams>
4. Web.xml stuff
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/Show</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
Hope this helps!
Regards,
Russ
-----Original Message-----
From: Jason Lanpher [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 11:38 AM
To: 'Tomcat Users List'
Subject: RE: Tomcat JDBC problem
Yes I am using com.mysql.jdbc.Driver
Here is the rest of the version numbers of the system.
RedHat 7.2 system
MySQL 3.56
Java 1.4.1_02
JDBC/MySQL 3.08
Jason Lanpher
[EMAIL PROTECTED]
http://www.stealthnetworking.com
Remember there are only 10 types of people in this world. Those who
understand Binary and those who don't.
-----Original Message-----
From: Pitre, Russell [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 10:25 AM
To: Tomcat Users List
Subject: RE: Tomcat JDBC problem
are you using "com.mysql.jdbc.Driver"?
-----Original Message-----
From: Jason Lanpher [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 11:08 AM
To: 'Tomcat Users List'
Subject: Tomcat JDBC problem
Hi all,
I am having a problem making the MySQL JDBC driver version 3
work with Tomcat correctly. I had previously used MySQL JDBC driver
version 1 and developed a couple of programs to access my MySQL
database. The programs worked just fine with this version of the
driver. When I went to upgrade to the newest version of the MySQL JDBC
driver I get errors in my programs saying there is an error before the
beginning of the result set. I am wondering if I am not installing the
driver correctly. All I did for the JDBC driver version 1 was to place
the jar file in CATALINA_HOME/common/lib I also made a CLASSPATH
variable and referenced the package. Since this worked I thought the it
should still work for the JDBC driver version 3. But for some reason it
does not.
Does anybody have any experience setting up JDBC driver 2 or 3
for MySQL that could give me a few tips on installation.
Thanks in advance,
Jason Lanpher
[EMAIL PROTECTED]
http://www.stealthnetworking.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
