db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: ResultSet holdability
Date Thu, 17 Nov 2005 19:21:21 GMT
Are you using embedded driver or network driver? Wonder if this is:
http://issues.apache.org/jira/browse/DERBY-694

Satheesh

Veaceslav Chicu wrote:

>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