db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Veaceslav Chicu ...@infologic.fr>
Subject ResultSet holdability
Date Thu, 17 Nov 2005 13:40:35 GMT
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

Mime
View raw message