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.
subject: ResultSets in Oracle does not see own inserts