Re: Mysql driver problem...
I got that same message myself many times. Are you trying from the root context? If so, you'll need resource-ref descriptionDB Connection/description res-ref-namejdbc/root/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref in web.xml and Context path=/root docBase=root debug=5 reloadable=true crossContext=true in server.xml that's what worked for me anyway Shawn On Mon, 2002-12-30 at 16:22, Keith Pemberton wrote: Ok, first off sorry if this is a little vague and I can write more details later. Anyway, I am new at this stuff with setting up the mysql driver to work with tomcat by setting a JNDI Datasource. I followed the directions under that heading in the documentation from the Tomcat website for the mysql driver, but I keep getting a Cannot load JDBC driver class 'null' message when I try to create a connection using the driver. I put the .jar file in the $TOMCAT/common/lib directory and restarted tomcat. Anyone have any quick tips for me to try? I can post my code later if yall need it; it's just late right now and I don't feel like cutting and pasting. Anyway, thanks in advance! Keith -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- shawn [EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: Mysql driver problem...
Well, my JNDI name for the resource is jdbc/gatep5 and that is what I have as the ResourceParams name=jdbc/gatep5. Then I translated that name into the web.xml which is under the ROOT directory of $Tomcat/webapps. Shouldn't this be ok? Keith On Mon, 2002-12-30 at 02:03, shawn wrote: I got that same message myself many times. Are you trying from the root context? If so, you'll need resource-ref descriptionDB Connection/description res-ref-namejdbc/root/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref in web.xml and Context path=/root docBase=root debug=5 reloadable=true crossContext=true in server.xml that's what worked for me anyway Shawn On Mon, 2002-12-30 at 16:22, Keith Pemberton wrote: Ok, first off sorry if this is a little vague and I can write more details later. Anyway, I am new at this stuff with setting up the mysql driver to work with tomcat by setting a JNDI Datasource. I followed the directions under that heading in the documentation from the Tomcat website for the mysql driver, but I keep getting a Cannot load JDBC driver class 'null' message when I try to create a connection using the driver. I put the .jar file in the $TOMCAT/common/lib directory and restarted tomcat. Anyone have any quick tips for me to try? I can post my code later if yall need it; it's just late right now and I don't feel like cutting and pasting. Anyway, thanks in advance! Keith -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- shawn [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]
Re: Mysql driver problem...
just like the example, I should think that would be ok. my point was Context path=/root docBase=root debug=5 reloadable=true crossContext=true and not sililar to the following which I found in server.xml !-- Tomcat Root Context -- !-- Context path= docBase=ROOT debug=0/ -- I tried Context path= docBase=ROOT debug=0/ and got the same message you did. On Mon, 2002-12-30 at 17:09, Keith Pemberton wrote: Well, my JNDI name for the resource is jdbc/gatep5 and that is what I have as the ResourceParams name=jdbc/gatep5. Then I translated that name into the web.xml which is under the ROOT directory of $Tomcat/webapps. Shouldn't this be ok? Keith On Mon, 2002-12-30 at 02:03, shawn wrote: I got that same message myself many times. Are you trying from the root context? If so, you'll need resource-ref descriptionDB Connection/description res-ref-namejdbc/root/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref in web.xml and Context path=/root docBase=root debug=5 reloadable=true crossContext=true in server.xml that's what worked for me anyway Shawn On Mon, 2002-12-30 at 16:22, Keith Pemberton wrote: Ok, first off sorry if this is a little vague and I can write more details later. Anyway, I am new at this stuff with setting up the mysql driver to work with tomcat by setting a JNDI Datasource. I followed the directions under that heading in the documentation from the Tomcat website for the mysql driver, but I keep getting a Cannot load JDBC driver class 'null' message when I try to create a connection using the driver. I put the .jar file in the $TOMCAT/common/lib directory and restarted tomcat. Anyone have any quick tips for me to try? I can post my code later if yall need it; it's just late right now and I don't feel like cutting and pasting. Anyway, thanks in advance! Keith -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- shawn [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] -- shawn [EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: Mysql driver problem...
Hi, for me the mysql driver worked fine, i used the Mark Matthews JDBC Driver for MySQL, put in under WEB-INF/lib of my application, and it got connected the first time.. - Original Message - From: Keith Pemberton To: Tomcat Users List Sent: Monday, December 30, 2002 1:39 PM Subject: Re: Mysql driver problem... Well, my JNDI name for the resource is jdbc/gatep5 and that is what I have as the ResourceParams name=jdbc/gatep5. Then I translated that name into the web.xml which is under the ROOT directory of $Tomcat/webapps. Shouldn't this be ok? Keith On Mon, 2002-12-30 at 02:03, shawn wrote: I got that same message myself many times. Are you trying from the root context? If so, you'll need resource-ref descriptionDB Connection/description res-ref-namejdbc/root/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref in web.xml and Context path=/root docBase=root debug=5 reloadable=true crossContext=true in server.xml that's what worked for me anyway Shawn On Mon, 2002-12-30 at 16:22, Keith Pemberton wrote: Ok, first off sorry if this is a little vague and I can write more details later. Anyway, I am new at this stuff with setting up the mysql driver to work with tomcat by setting a JNDI Datasource. I followed the directions under that heading in the documentation from the Tomcat website for the mysql driver, but I keep getting a Cannot load JDBC driver class 'null' message when I try to create a connection using the driver. I put the .jar file in the $TOMCAT/common/lib directory and restarted tomcat. Anyone have any quick tips for me to try? I can post my code later if yall need it; it's just late right now and I don't feel like cutting and pasting. Anyway, thanks in advance! Keith -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- shawn [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]
Re: Mysql driver problem...
I got it to work finally. I actually had to use the Context path= docBase=ROOT debug=5 reloadable=true crossContext=true As soon as I did that everything was fine. Thanks for the help and suggestions. Keith On Mon, 2002-12-30 at 02:39, shawn wrote: just like the example, I should think that would be ok. my point was Context path=/root docBase=root debug=5 reloadable=true crossContext=true and not sililar to the following which I found in server.xml !-- Tomcat Root Context -- !-- Context path= docBase=ROOT debug=0/ -- I tried Context path= docBase=ROOT debug=0/ and got the same message you did. On Mon, 2002-12-30 at 17:09, Keith Pemberton wrote: Well, my JNDI name for the resource is jdbc/gatep5 and that is what I have as the ResourceParams name=jdbc/gatep5. Then I translated that name into the web.xml which is under the ROOT directory of $Tomcat/webapps. Shouldn't this be ok? Keith On Mon, 2002-12-30 at 02:03, shawn wrote: I got that same message myself many times. Are you trying from the root context? If so, you'll need resource-ref descriptionDB Connection/description res-ref-namejdbc/root/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource-ref in web.xml and Context path=/root docBase=root debug=5 reloadable=true crossContext=true in server.xml that's what worked for me anyway Shawn On Mon, 2002-12-30 at 16:22, Keith Pemberton wrote: Ok, first off sorry if this is a little vague and I can write more details later. Anyway, I am new at this stuff with setting up the mysql driver to work with tomcat by setting a JNDI Datasource. I followed the directions under that heading in the documentation from the Tomcat website for the mysql driver, but I keep getting a Cannot load JDBC driver class 'null' message when I try to create a connection using the driver. I put the .jar file in the $TOMCAT/common/lib directory and restarted tomcat. Anyone have any quick tips for me to try? I can post my code later if yall need it; it's just late right now and I don't feel like cutting and pasting. Anyway, thanks in advance! Keith -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- shawn [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] -- shawn [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]
Mysql driver problem...
Ok, first off sorry if this is a little vague and I can write more details later. Anyway, I am new at this stuff with setting up the mysql driver to work with tomcat by setting a JNDI Datasource. I followed the directions under that heading in the documentation from the Tomcat website for the mysql driver, but I keep getting a Cannot load JDBC driver class 'null' message when I try to create a connection using the driver. I put the .jar file in the $TOMCAT/common/lib directory and restarted tomcat. Anyone have any quick tips for me to try? I can post my code later if yall need it; it's just late right now and I don't feel like cutting and pasting. Anyway, thanks in advance! Keith -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
MySQL Driver Problem on Win 2k
Hi All, Thank you for your answers until now. I have one more problem! I have MySQL 3.23.XXX installed on a Win 2000 system and I have TOMCAT 3.2.1 running with no problems! If I start TOMCAT SERVICE and I try to connect throw a JSP page, I got an error like org.gjt.mm.etc driver not found, but if I start TOMCAT manualy, I a have no problem! The org\gjt\mm\mysql\... subdir tree it's in a directory called JDBC and I've added c:\JDBC in my CLASSPATH. What's wrong? Evdin
RE: MySQL Driver Problem on Win 2k
sorry cant chat!! but add the .jar file to the /tomcat/server/lib directory.. its the classpath classloader location. -Original Message- From: Evdin Ursan [mailto:[EMAIL PROTECTED]] Sent: Monday, 23 April 2001 4:44 PM To: [EMAIL PROTECTED] Subject: MySQL Driver Problem on Win 2k Hi All, Thank you for your answers until now. I have one more problem! I have MySQL 3.23.XXX installed on a Win 2000 system and I have TOMCAT 3.2.1 running with no problems! If I start TOMCAT SERVICE and I try to connect throw a JSP page, I got an error like org.gjt.mm.etc driver not found, but if I start TOMCAT manualy, I a have no problem! The org\gjt\mm\mysql\... subdir tree it's in a directory called JDBC and I've added c:\JDBC in my CLASSPATH. What's wrong? Evdin
SV: MySQL Driver Problem on Win 2k
Hi, I had the same problem when I had to run Tomcat as a Win2K service. In fact I posted the problem here but I didn't get any satisfactory answers until went to the docs. Now here's what you do: 1. Edit the wrapper.properties file found in the conf directory of your Tomcat installation. 2. Add a line like this: wrapper.class_path=$(wrapper.tomcat_home)\lib\driver.jar (where driver is the name of your MySQL driver). Make sure the jar file is located in the lib directory - it could be anywhere actually, but that is how mine is. 3. Make sure the wrapper.tomcat_home property is set correctly. Mine is: wrapper.tomcat_home=c:\jboss_tomcat\tomcat 4. Restart the Tomcat service. That's it! Paul From: Warren Crossing [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: MySQL Driver Problem on Win 2k Date: Mon, 23 Apr 2001 17:04:36 +1000 sorry cant chat!! but add the .jar file to the /tomcat/server/lib directory.. its the classpath classloader location. -Original Message- From: Evdin Ursan [mailto:[EMAIL PROTECTED]] Sent: Monday, 23 April 2001 4:44 PM To: [EMAIL PROTECTED] Subject: MySQL Driver Problem on Win 2k Hi All, Thank you for your answers until now. I have one more problem! I have MySQL 3.23.XXX installed on a Win 2000 system and I have TOMCAT 3.2.1 running with no problems! If I start TOMCAT SERVICE and I try to connect throw a JSP page, I got an error like org.gjt.mm.etc driver not found, but if I start TOMCAT manualy, I a have no problem! The org\gjt\mm\mysql\... subdir tree it's in a directory called JDBC and I've added c:\JDBC in my CLASSPATH. What's wrong? Evdin _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Rãspuns: MySQL Driver Problem on Win 2k
Hi, THANK YOU VERY MUCH! IT WORKED! EVDIN -Mesaj original- De la: Paul Kofon [mailto:[EMAIL PROTECTED]] Trimis: 23 aprilie 2001 10:50 Catre: [EMAIL PROTECTED] Subiect: SV: MySQL Driver Problem on Win 2k Hi, I had the same problem when I had to run Tomcat as a Win2K service. In fact I posted the problem here but I didn't get any satisfactory answers until went to the docs. Now here's what you do: 1. Edit the wrapper.properties file found in the conf directory of your Tomcat installation. 2. Add a line like this: wrapper.class_path=$(wrapper.tomcat_home)\lib\driver.jar (where driver is the name of your MySQL driver). Make sure the jar file is located in the lib directory - it could be anywhere actually, but that is how mine is. 3. Make sure the wrapper.tomcat_home property is set correctly. Mine is: wrapper.tomcat_home=c:\jboss_tomcat\tomcat 4. Restart the Tomcat service. That's it! Paul From: Warren Crossing [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: MySQL Driver Problem on Win 2k Date: Mon, 23 Apr 2001 17:04:36 +1000 sorry cant chat!! but add the .jar file to the /tomcat/server/lib directory.. its the classpath classloader location. -Original Message- From: Evdin Ursan [mailto:[EMAIL PROTECTED]] Sent: Monday, 23 April 2001 4:44 PM To: [EMAIL PROTECTED] Subject: MySQL Driver Problem on Win 2k Hi All, Thank you for your answers until now. I have one more problem! I have MySQL 3.23.XXX installed on a Win 2000 system and I have TOMCAT 3.2.1 running with no problems! If I start TOMCAT SERVICE and I try to connect throw a JSP page, I got an error like org.gjt.mm.etc driver not found, but if I start TOMCAT manualy, I a have no problem! The org\gjt\mm\mysql\... subdir tree it's in a directory called JDBC and I've added c:\JDBC in my CLASSPATH. What's wrong? Evdin _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.