ResultSet Cache
Posted by: Deeks Man
Date: October 26, 2008 02:23AM

Hi All,
I am running a query using JDBC on my table. I get the proper result. The keep the application still running (UI), I create a new row using commandline line. The is immediately commited. When I run the query in the first application, the new row is not part of the rersult. I have to restart the first application to have this new row included in the result.
For me it looks like resultset cache is being used, because the second time, the query executes more than 4 times faster.

Can anybody help me to resolve this

Thanks
D M

Options: ReplyQuote


Subject
Written By
Posted
ResultSet Cache
October 26, 2008 02:23AM
October 28, 2008 08:30AM
October 30, 2008 01:45AM
October 31, 2008 02:57AM
November 02, 2008 06:02AM
November 03, 2008 02:06AM


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.