jQuery in Action, 2nd edition*
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


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
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.
 
Don't get me started about those stupid light bulbs.
 
subject: ResultSets in Oracle does not see own inserts