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]
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]
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]
RE: Tomcat JDBC problem
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.jarin CATALINA_HOME\common\lib 2.. Didn't worry about setting the classpath for it... 3.. Server.xml stuff parameter nameusername/name valuetomcat/value /parameter parameter namepassword/name valuesinner/value /parameter !-- Class name for MySQL jdbc driver-- parameter namedriverClassName/name valuecom.mysql.jdbc.Driver/value /parameter !--JDBC Connection URL-- parameter nameurl/name valuejdbc:mysql://localhost/tomcatbook?autoReconnect=true/value /parameter /ResourceParams 4. Web.xml stuff resource-ref descriptionDB Connection/description res-ref-namejdbc/Show/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/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]
