I just tried removing the mysql drivers from my 2k box, and got the same
exception as you. They are working for me from the common lib folder.
I'd advise you to take a quick peek inside the jar file. make sure
com.mysql.jdbc.Driver and other classes are actually there, under the
correct package name.
Mehdi
Martin Jacobson
<martin_j@libero. To: Tomcat Users List
<[EMAIL PROTECTED]>
it> cc:
Subject: Re: MySql connection pool
difficulties
14/02/2003 08:50
Please respond to
"Tomcat Users
List"
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>
> 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.
Your config looks OK - I compared it to mine (which works!), and could
see nothing out of the ordinary.
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
