Hello,
conn.setAutoComit(true);
I have a unsensitive readonly result set:
conn.prepareStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT))
...
after that I execute a stored procedure:
conn.prepareCall("{call procedure(?, ?, ?)}")
...
if I have an exception in my procedure, first resultSet will close?
normaly in my client application I shoud reexecute my select?
thank you,
Slavic
P.S. I have a JTable that shows results of un select, I have a button
that execute a stored procedure, normaly if procedure fails it should'nt
affect my select
