Re: Troubles with accessing remote database
Posted by: Todd Farmer
Date: November 21, 2012 10:46AM

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/

Options: ReplyQuote


Subject
Written By
Posted
B V
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.