Re: Troubles with accessing remote database
Hi B V,
You'll probably want to add debugging to your JDBC application to understand where it hangs. There's really three options:
1. The hang has nothing to do with establishing a connection to MySQL
2. The hang is caused by network before the MySQL server is ever contacted.
3. The hang happens during or after authentication on the server.
If the problem is #3, you'll see this connection - in some state, possibly unauthenticated user - when you run SHOW FULL PROCESSLIST on the MySQL server. You can also capture connection events with log-warnings:
http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_log-warnings
If the problem is one of the first two causes, the only reasonable way to diagnose this is to add debugging to the Java code.
Hope that helps,
--
Todd Farmer
MySQL @ Oracle
http://www.oracle.com/mysql/
Subject
Written By
Posted
November 10, 2012 11:47AM
Re: Troubles with accessing remote database
November 21, 2012 10:46AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.