I'm trying to setup Tomcat 5.0.25 to talk to a MySQL database and I've had
no luck after several days of fighting with this thing. I'm following along
the documentation at this URI:
http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-how
to.html
The example says to edit
If the webapps.xml file is supposed to be located in Catalina\localhost, the
apache's own website documentation JDBC-HOWTO needs to be updated to reflect
that new situation. I'm surprised they haven't updated it because I'm sure
a lot of other people are going to be having the same problems I am.
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
and password for the database or put in bogus ones for the
purposes of posting to the list? An excerpt of your java code where you
attempt to access the db would be good as well.
--David
Briggs, Patrick wrote:
Ok, I have it in the common/lib directory, but that didn't make a
difference. You'd
just
before the closing /web-app tag. In tomcat versions 3 and 4, the
order of elements in web.xml was important. I believe that requirement
has been lifted in tomcat 5.
--David
Try that and see what happens.
--David
Briggs, Patrick wrote:
I'm using an example someone else on this list
5.
--David
Try that and see what happens.
--David
Briggs, Patrick wrote:
I'm using an example someone else on this list gave me.
So inside of {CATALINA_HOME}/conf/Catalina/localhost/DBTest.xml
?xml version='1.0' encoding='utf-8'?
Context debug=5 displayName=DBtest docBase=DBTest path=/DBtest
: Tomcat - MySQL = No suitable driver ERROR
I have seen this one too many times. It usually has to do with the naming
lookup. I have had to keep playing with the form of the name until it
worked.
Robert S. Harper
801.265.8800 ex. 255
-Original Message-
From: Briggs, Patrick [mailto:[EMAIL
.../ResourceParams sections to define a connection
pool and make it available in tomcat's JNDI name space. web.xml needs
the resource-ref.../resource-ref stuff to make the connection pool
avialable to your application.
--David
Briggs, Patrick wrote:
Ok, I tried as you suggested, I deleted
David had me do this following proceedure and that seemed to work, but my
JSP does not return any data so far. The database finally connected though.
When I view this JSP page, all it prints is:
${row.foo} ${row.bar}
instead of the data that should be contained inside those variables.