db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: Error: Invalid cursor state - no current row.
Date Mon, 29 Oct 2007 12:09:42 GMT
"Bit Runner..." <bitrunner@katamail.com> writes:

> Exact: I have put setAutoCommit(false) and all it works correctly!!! :-))))
> Thanks
> PS: an other question: but in AutoCommit true the every instruction
> sql is executed in one isolated transaction. And therefore why it gave
> error to me? In theory it would have to give it with AutoCommit false.

Your two SQL statements weren't executed in different transactions
(there's only one active transaction for each java.sql.Connection), so
when rsOpzioni was closed, the transaction in which both rsOpzioni *and*
rsPreventivi were executed, was committed.

Knut Anders

View raw message