wood burning stoves 2.0*
The moose likes JDBC and the fly likes ResultSets in Oracle does not see own inserts Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ResultSets in Oracle does not see own inserts" Watch "ResultSets in Oracle does not see own inserts" New topic
Author

ResultSets in Oracle does not see own inserts

Rich Wright
Greenhorn

Joined: Oct 08, 1999
Posts: 17
I was wondering if there is a work around with Oracle not being able to see their own inserts.
This is from the JDBC 2.0 Oracle Documentation:
"Internal INSERT operations are never visible, regardless of the result set type (neither forward-only, scroll-sensitive, nor scroll-insensitive)."
This creates a big problem for me because I populate a JTable using the ResultSet and the allow a user to insert, update, and delete rows. The ResultSet not seeing own inserts is a big problem because the JTable reflects whatever is in the ResultSet and therefore does not show the inserted row.
I really do not want to have to store the ResultSet in a Vector (or any other Collection) because I do not what to have to deal with keeping the Vector and ResultSet synchronized.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ResultSets in Oracle does not see own inserts
 
Similar Threads
adding a blank row to a JTable
JTable
JTable Help
JTable
JTable