Hi Paul
One thing I seem to remember is that there are several different
versions of the jdbc driver for mysql and I seem to remember getting
this problem with an older version of the driver.... (we use
mysql-connector-java.3.0.10-stable-bin.jar with mysql 4.x)
If this doesnt work there are several other things to try:
* If you can telnet on port 3306 to the server then it is unlikely that
it is a firewall problem and the server is probably running and
accepting connections (can you connect to server using plain old mysql
client? )
* I tend to agree with Brian - it sounds like a config problem in your
code or with the jdbc connection string (NumberFormatException might
mean that the port is beign screwed up, try and explicitly specify it).
* Why dont you try to connect with a java database client like squirrel or datastudio.
The connection string for the mysql jdbc driver is jdbc:mysql://<hostname>[<:3306>]/<dbname>.
You could try and drop the user and password off and specify the port
on the connection string and see if the error message changes.
* You could run tcpdump and catch the packets destined to 3306 (you
might be able to debug what is going on from this) but this could be a
painful procedure.
Hope this helps...
Steve van der Merwe
Magmatec Pty Ltd
Phone +27 (0)83 700 2988 (mobile)
+27 (0)21 670 7926 (work)
