Closing Resultset for a streaming Result hangs
Posted by:
Zunil John
Date: March 03, 2009 04:08AM
Hi All,
One of the queries used returns a large resultset(but ata time requires a subset).
So in common scenario, this will throw out of memory error.
We tried server cursor(by using useCursorFetch and defaultFechSize). But here MySQL creates a temp table, which takes lot of time
Then we tried streaming resultset as suggested by MySQL.
We retrieved the first set(ex:50 records) and when I try to close the resultset so that locks can be cleared, it hangs.
resultSet.close() is not responding.
It takes lot of time to move to next statement
Any idea why close() is taking lot of time?
Any solution to this?
We tested this with MySQL server 5.0.67 and 5.0.8 JDBC driver.
We cannot use LIMIT as the queries are generic nad the product can be deployed in multiple DB servers.
Subject
Written By
Posted
Closing Resultset for a streaming Result hangs
March 03, 2009 04:08AM
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.