Win a copy of The Way of the Web Tester: A Beginner's Guide to Automating Tests this week in the Testing forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ResultSets in Oracle does not see own inserts

Rich Wright
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic