tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Pedersen" <>
Subject Re: configuration issue
Date Wed, 14 May 2008 17:59:14 GMT
2008/5/14 Christopher Schultz <>:

> Hash: SHA1
> John,
> John Pedersen wrote:
> | Cannot create JDBC driver of class '' for connect URL 'null'
> This comes up quite often. Unfortunately, any number of bad
> configuration options can result in this message.

You 're - it is a common error. Shame the message isn't more specific about
what is causing it.

> |    <Resource name="compatMYSQL" auth="Container"
> type="javax.sql.DataSource"
> The resource name is usually of the form "jdbc/compatMYSQL".

I had that at one stage.  But without the jdbc/ seems to work as well.

> |     factory="org.apache.commons.dbcp.BasicDataSourceFactory"
> You should not need to specify this, though it shouldn't hurt.
> | This arrangement works on my local machine, but it throws the error on my
> | hosting server ( private JVM, Tomcat 6, on *nix *Virtual* Private
> *Server )
> Where is mysql-connector-x.y.z.jar installed on your local server? On
> the hosting server? Make sure that your JDBC library exists only in a
> single place on the server. For our projects, we put it in common/lib
> (on TC 5.5... I think it's just /lib for TC 6).

Yep, in /lib, it is TC 6

> | To fix it, I had to delete *META-INF/context.xml, and put the context
> info
> | in server.xml ( which the Tomcat documentation recommends NOT doing).
> Yeah, put it back into context.xml... it should work if everything else
> is okay.

This is the point! It should work, but it doesn't. It ONLY works with the
config info in server.xml

> | After spending so long resolving this, I am curious as to why it
> happened.
> These things usually get resolved when the configuration is re-written.
> Some little tiny thing was typo'd or mis-copied or whatever and the
> re-write fixes everything. Nobody keeps the old config and bothers to do
> a diff, so the exact cause usually remains a mystery. :)

I've spent SOOO long on it, it is hard to let go! I am curious why it might
work only with server.xml, and not in META-INF/context.xml.

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message