Hi Martin,
My MySQL server is alive and well; I can connect to it using the same
parameters, using a JDBC-based database browser.
I didn't know about autoReconnect being deprecated; it still appears to
be supported, but I see that the MySQL 5.0 reference manual recommends
cranking up the
The MySQL driver is in $TOMCAT_HOME/lib, but I don't think that is even
the issue here -- the real problem is that the DataSource object is not
initialized, so it doesn't even have the url, driver class name, etc.
This is what my log looks like when I restart Tomcat:
Dec 7, 2007 1:18:50 PM
Hi Tom
here is my jdbc.properties which is used for petstore access to MySQL tables
#jdbc.driverClassName=org.hsqldb.jdbcDriver
jdbc.driverClassName=com.mysql.jdbc.Driver
#jdbc.url=jdbc:hsqldb:hsql://localhost:9001
jdbc.url=jdbc:mysql://localhost:3306/petclinic
jdbc.username=fu
jdbc.password=bar
Where did you place your mysql driver jar file? It has to be in
tomcat's /lib directory to be visible to tomat's internal code for
building the db pool and your webapp. Also did you happen to look at
the logs around when your webapp started for any relevant messages?
--David
Thomas Okken
Ok...
The other statistical common thread in this type of issue is a typo or
missing config somewhere along the line in one of these files:
context.xml -- you've provided that and named the resource jdbc/SmmDB
web.xml -- do you have this in your WEB-INF/web.xml:
resource-ref
You're right, it was a typo! I called the datasource SmmDS everywhere,
except in the Context element, where I mistakenly called it SmmDB.
I think it's pretty weird that the JNDI lookup succeeded anyway. That
sounds like a Tomcat bug; it should throw a NameNotFoundException, not
return an
Hi all,
I'm trying to set up a DataSource to manage connections to a MySQL
database, but whenever I call getConnection(), I get this error:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of
class '' for connect URL 'null'
at