When I pass a query from my Java application to mysql server, it stays in
Sending Data state and not returning result set back to application.
When I execute the same query in SQLYog directly, it works fine and returns 1000 row(s) with following details
Execution Time : 21.060 sec Transfer Time : 3 min 11 sec Total Time : 3 min 33 sec
I am not getting any kind of exception for debugging.
I am using the following
- mysql server 5.5
- JDK 7
- apache tomcat server 7.0.27