"Bit Runner..." <[EMAIL PROTECTED]> 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
