Tom O'Neil wrote:
After scouring the mailing list and a few forums, I'm
still at a dead end attempting to get MySql connection
pooling working with Tomcat. I'm running the following
on Windows 2000:
Tomcat 4.1.18
MySql 4.0.10
JDK 1.4.1
I've tried using both the MySql 3.0.5 and 2.0.14
drivers. I've placed these in [tomcat root]\common\lib
(only one at a time - never both simultaenously). I
know my code and web.xml are pretty solid, because I'm
porting a funtional app from WebSphere 5.0.
<snip>
Your config looks OK - I compared it to mine (which works!), and could see nothing out of the ordinary.And the error I'm getting is: "Cannot create JDBC driver of class 'com.mysql.jdbc.Driver' for connect URL 'jdbc:mysql//localhost:3306/dsdemo?autoReconnect=true'" It seems that a fair amount of other folk have encountered this same problem, but I have to stumble across a solutions. Any help would be appreciated.
But, is your error message complete? A problem I had to begin with was that since Java can only create 'proper' sockets (ie not UNIX_SOCKETs), mysql was actually receiving a connection request from <my.domain.name>, and NOT from localhost. Since I only had mysql authorisation set up for localhost, the connection was refused. The correction was obvious once I spotted it!
However, this was on a Unix Box (Mac OS X, actually), so under Windows, things may be different.
HTH !
Martin
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
