-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

William R. Mussatto wrote:

>>Tried it and now I get connection timed out after three tries.  I'm
>>running the testbed using the tomcat buried in netbeans.  Cut and pasted
>>the example from the on line docs.  Put the jar in the WEB-INF/lib
>>dirctory.  Compiles fine..  I'm using the in line driver registration
>>rather than modifying the
>>web.xml file.
>>
>>Tested user on the same box with command line client using the
>>--host=localhost and it connected fine (had run grant all for the
>>'username'@'localhost' earlier.  Any thoughts?
>>
>>Of course I've been using your old mm version with 3.23.x (to match our
>>debian install).
>>
>>With 4.7.1 both the old mm connector and the current connector/J both
>>time out.  Anythink I should check. And no. there is no local firewll
>>installed on the box.
> 
> Follow up w/specific error reports:
> SQLException: Server connection failure during transaction.
> Attempted reconnect 3 times. Giving up.
> SQLState: 08001
> VendorError: 0

What is the error message with the _new_ version of Connector/J (it
should have more information in it, as the code that throws the
exception you give looks like this:

throw new SQLException(
                    "Server connection failure during transaction. Due
to underlying exception: '"
                    + connectionException + "'."
                    + (this.paranoid ? ""
                                     : Util.stackTraceToString(
                        connectionException)) + "\nAttempted reconnect "
                    + this.maxReconnects + " times. Giving up.",
                    SQLError.SQL_STATE_UNABLE_TO_CONNECT_TO_DATASOURCE);

)

That 'underlying exception' bit will be important for anyone who is
trying to figure out why you're having problems!

        -Mark
- --
Mark Matthews
MySQL AB, Software Development Manager - Client Connectivity
Office: +1 708 332 0507
www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBopQ5tvXNTca6JD8RAuYXAKCYUaqoE8kgFoIRjX1/bhnWV16rRwCgu0Yg
YaG8VeNFXEYq/0eIF03mxQI=
=HsNZ
-----END PGP SIGNATURE-----

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to