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.

Options: ReplyQuote


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.