JDBC MySQL will not connect (but MySQL Administrator will)
Post by:Stepan Kolesnik
Hi, I am close to the stage of growing some hair on my bold head and then ripping them out. I really can't figure out what is going on, but the situation is like this: 1) MySQL server #1 is located on the remote machine (Version 4.0.24); 2) MySQL server #2 is located on my local machine (Version 5.1.11); 3) Servers have identical schemas; 4) I am using Sun JDK1.6.0_04; 5) I am using MySQL� Connector/J 5.1; 6) I can connect to BOTH servers via MySQL Administrator!; 7) I can connect ONLY to server #2 via JDBC; 8) When trying to connect ot server #1 via JDBC, getConnection() hangs up, and if ConnectionTimout and SocketTimeout are explicitly specified, connection timeout exception is then thrown;
I have tried modifying connection string in various ways, even SSH TUNNELING to the remote server, but no result. And MySQL Administrator just works without ANY problems! I have a feeling there must be something crucial that I am missing. Could anyone help? Thank you in advance.
Post by:Jan Cumps
MySQL server #1 is located on the remote machine (Version 4.0.24); 2) MySQL server #2 is located on my local machine (Version 5.1.11); ... 5) I am using MySQL� Connector/J 5.1;