-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
William R. Mussatto wrote:
> Mark Matthews said:
>
>>-----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
>
> Dropped back to server version 4.0.22 and it works (at least to the extent
> of getting normal jsp errors rather than connection errors). I'll try to
> look at it later, but I've lost about a week w/4.1 connectivity issues so
> I have to get what works out.
> ? I thought I was using the latest current stable version of connector/J.
William,
That exception message you print isn't coming from the current stable
version of Connector/J (3.0.16), I can just about assure you of that ;)
Please try with 3.0.16 if you can.
-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
iD8DBQFBoqSCtvXNTca6JD8RAhCiAJ0R0ti3Q0ZX5p4X+8AjmLiU9fJ1TQCeMUg6
QYRfHRVQfwkZg3OcodcnC4A=
=JrJV
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
