-----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]