RE: Tomcat - MySQL = No suitable driver ERROR

2004-07-02 Thread Jan Behrens
: Thursday, July 01, 2004 7:59 PM To: 'Tomcat Users List' Cc: '[EMAIL PROTECTED]' Subject: RE: Tomcat - MySQL = No suitable driver ERROR Ok, the contents of {TOMCAT_HOME}/conf/Catalina/localhost/DBTest.xml is: Context debug=5 displayName=DBtest docBase=DBTest path=/DBtest reloadable=true workDir=work

RE: Tomcat - MySQL = No suitable driver ERROR

2004-07-02 Thread Briggs, Patrick
- This exact formula has worked for me in I can't even count how many apps I've setup. --David -Original Message- From: Jan Behrens [mailto:[EMAIL PROTECTED] Sent: Friday, July 02, 2004 1:50 AM To: 'Tomcat Users List' Subject: RE: Tomcat - MySQL

RE: Tomcat - MySQL = No suitable driver ERROR

2004-07-02 Thread Jan Behrens
problem. I am sure that someone will know... Jan -Original Message- From: Briggs, Patrick [mailto:[EMAIL PROTECTED] Sent: Friday, July 02, 2004 6:36 PM To: 'Tomcat Users List' Subject: RE: Tomcat - MySQL = No suitable driver ERROR David had me do this following proceedure and that seemed

RE: Tomcat - MySQL = No suitable driver ERROR

2004-07-01 Thread Jan Behrens
AM To: Tomcat Users List Subject: Re: Tomcat - MySQL = No suitable driver ERROR Ok. I think I'm seeing your trouble. The stuff you have in WEB-INF/DB-Test.xml should be in web.xml instead. In mine, the resource-ref.../resource-ref stuff is at the end of the file just before the closing /web

RE: Tomcat - MySQL = No suitable driver ERROR

2004-07-01 Thread Briggs, Patrick
: Wednesday, June 30, 2004 6:56 PM To: Tomcat Users List Subject: Re: Tomcat - MySQL = No suitable driver ERROR Ok. I think I'm seeing your trouble. The stuff you have in WEB-INF/DB-Test.xml should be in web.xml instead. In mine, the resource-ref.../resource-ref stuff is at the end of the file

RE: Tomcat - MySQL = No suitable driver ERROR

2004-07-01 Thread Briggs, Patrick
- From: Jan Behrens [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 1:04 AM To: 'Tomcat Users List' Subject: RE: Tomcat - MySQL = No suitable driver ERROR David is right, you will need to rename {Catalina_Home}/webapps/DBTest/WEB-INF/DBTest.xml to {Catalina_Home}/webapps/DBTest/WEB-INF

RE: Tomcat - MySQL = No suitable driver ERROR

2004-07-01 Thread Robert Harper
, 2004 10:20 AM To: 'Tomcat Users List' Subject: RE: Tomcat - MySQL = No suitable driver ERROR Yeah, I just tried that and still no go. Still getting: javax.servlet.ServletException: Unable to get connection, DataSource invalid: org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC

RE: Tomcat - MySQL = No suitable driver ERROR

2004-07-01 Thread Briggs, Patrick
PROTECTED] Sent: Thursday, July 01, 2004 10:20 AM To: 'Tomcat Users List' Subject: RE: Tomcat - MySQL = No suitable driver ERROR Yeah, I just tried that and still no go. Still getting: javax.servlet.ServletException: Unable to get connection, DataSource invalid

Re: Tomcat - MySQL = No suitable driver ERROR

2004-07-01 Thread David Smith
Users List Subject: Re: Tomcat - MySQL = No suitable driver ERROR Ok. I think I'm seeing your trouble. The stuff you have in WEB-INF/DB-Test.xml should be in web.xml instead. In mine, the resource-ref.../resource-ref stuff is at the end of the file just before the closing /web-app tag

Re: Tomcat - MySQL = No suitable driver ERROR

2004-07-01 Thread Hassan Schroeder
David Smith wrote: I was recommending you take the resource-ref.../resource-ref stuff you put in {TOMCAT_HOME}/webapps/DBTest/WEB-INF/DBTest.xml and put that in {TOMCAT_HOME}/webapps/DBTest/WEB-INF/web.xml. Yes, and in addition -- Here is what my web.xml looks like now: ?xml version=1.0

RE: Tomcat - MySQL = No suitable driver ERROR

2004-07-01 Thread Briggs, Patrick
/resource-ref /web-app Is this what you wanted? -Original Message- From: David Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 10:25 AM To: Tomcat Users List Subject: Re: Tomcat - MySQL = No suitable driver ERROR Hold on a minute. I think we have a communication problem

RE: Tomcat - MySQL = No suitable driver ERROR

2004-06-30 Thread Jan Behrens
Hi Patrick, the problem might be that in Tomcat 5.x the storage of the context related configuration changed from server.xml to a sepparate file for each webapp. This file should be stored under {Catalina_Home}\conf\Catalina\{domain-name}\myWebAppName.xml where Catalina_Home points to your Tomcat

RE: Tomcat - MySQL = No suitable driver ERROR

2004-06-30 Thread Briggs, Patrick
it where it needs changes for URL and username/password. Still getting the same error message :( So now what could it be? -Original Message- From: Jan Behrens [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 1:58 AM To: 'Tomcat Users List' Subject: RE: Tomcat - MySQL = No suitable

Re: Tomcat - MySQL = No suitable driver ERROR

2004-06-30 Thread David Smith
Behrens [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 1:58 AM To: 'Tomcat Users List' Subject: RE: Tomcat - MySQL = No suitable driver ERROR Hi Patrick, the problem might be that in Tomcat 5.x the storage of the context related configuration changed from server.xml to a sepparate file

RE: Tomcat - MySQL = No suitable driver ERROR

2004-06-30 Thread Briggs, Patrick
12:19 PM To: Tomcat Users List Subject: Re: Tomcat - MySQL = No suitable driver ERROR Wrong place for mysql jar file. It should be in {TOMCAT_HOME}/common/lib right along side the DBCP jar file. --David Briggs, Patrick wrote: If the webapps.xml file is supposed to be located in Catalina

Re: Tomcat - MySQL = No suitable driver ERROR

2004-06-30 Thread David Smith
[mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 12:19 PM To: Tomcat Users List Subject: Re: Tomcat - MySQL = No suitable driver ERROR Wrong place for mysql jar file. It should be in {TOMCAT_HOME}/common/lib right along side the DBCP jar file. --David Briggs, Patrick wrote

RE: Tomcat - MySQL = No suitable driver ERROR

2004-06-30 Thread Jan Behrens
the ressource. HTH, Jan -Original Message- From: Briggs, Patrick [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 9:47 PM To: 'Tomcat Users List' Subject: RE: Tomcat - MySQL = No suitable driver ERROR Ok, I have it in the common/lib directory, but that didn't make a difference. You'd think

RE: Tomcat - MySQL = No suitable driver ERROR

2004-06-30 Thread Briggs, Patrick
: David Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 1:33 PM To: Tomcat Users List Subject: Re: Tomcat - MySQL = No suitable driver ERROR I've set this up I don't know how many times and only ever had problems when I've mispelled the JNDI name I gave it somewhere in the 4 places

Re: Tomcat - MySQL = No suitable driver ERROR

2004-06-30 Thread David Smith
) javax.servlet.http.HttpServlet.service(HttpServlet.java:810) -Original Message- From: David Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004 1:33 PM To: Tomcat Users List Subject: Re: Tomcat - MySQL = No suitable driver ERROR I've set this up I don't know how many times and only ever had problems when I've

Re: Tomcat - MySQL = No suitable driver ERROR

2004-06-30 Thread David Smith
PROTECTED] Sent: Wednesday, June 30, 2004 9:47 PM To: 'Tomcat Users List' Subject: RE: Tomcat - MySQL = No suitable driver ERROR Ok, I have it in the common/lib directory, but that didn't make a difference. You'd think there would be a lot easier way to setup stuff like this. Editing XML files

RE: Tomcat - MySQL = No suitable driver ERROR

2004-06-29 Thread FRANCOIS Dufour
here maybee it could help you! im using mysql database whit Tomcat4.0 and the config look like this! first download mysql-connector-java-3.0.10-stable-bin read install instruction (or simply copy the file under Tomcat_home/comon/lib) the conection acess to database ! xml