pawan2009 wrote:
BTW, I am using:
stmt = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
to get the resultset while adding records in another thread.
Hi,
Are you able to explain the behavior you see after having read the
documentation below?
http://db.apache.org/derby/docs/dev/devguide/devguide-single.html#rdevconceptssur
What you describe should not happen if you indeed inserted the record
and committed the transaction before you select from the table, but I
know there are some special rules applying to scrollable result sets.
Maybe someone with more detailed knowledge about scrollable result sets
can advice you better.
BTW: For future inquiries of this kind, you may be better of posting
them to the users list.
Regards,
--
Kristian
