Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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
  • mysql-connector-java-5.1.20
  • apache tomcat server 7.0.27
share|improve this question
    
I believe it happens because your query returns too many rows, and SQLYog either limits the number of rows it shows or displays just portion of result set as soon as possible. Also, you may want to check stackoverflow.com/questions/1031484/… –  a1ex07 May 28 '12 at 19:33
    
thanks for help dear , your guidance has helped me to resolve problem actually sql yog was returning only 1000 rows out of 6886 rows's of result set so final outcome comes back into application after 25 min –  user1409935 Jun 1 '12 at 3:19
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.