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]
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