Re: Transaction Problems of a Derby Stored Procedure

2008-02-16 Thread sin(EaTing),
That's great. Thanks. On Feb 16, 2008 6:51 PM, <[EMAIL PROTECTED]> wrote: > "sin(EaTing)," <[EMAIL PROTECTED]> writes: > > > Thanks, Dan. > > The document I read seems already the latest, which is Derby Developer's > > Guide Version 10.3. > > And I am still confused about the isolation mode, I tr

Re: Transaction Problems of a Derby Stored Procedure

2008-02-16 Thread Dyre . Tjeldvoll
"sin(EaTing)," <[EMAIL PROTECTED]> writes: > Thanks, Dan. > The document I read seems already the latest, which is Derby Developer's > Guide Version 10.3. > And I am still confused about the isolation mode, I traced the stored > procedure using getTransactionIsolation() and the return value shows

Re: Transaction Problems of a Derby Stored Procedure

2008-02-15 Thread sin(EaTing),
Thanks, Dan. The document I read seems already the latest, which is Derby Developer's Guide Version 10.3. And I am still confused about the isolation mode, I traced the stored procedure using getTransactionIsolation() and the return value shows the isolation level was changed, I am not sure about t

Re: Transaction Problems of a Derby Stored Procedure

2008-02-15 Thread Daniel John Debrunner
sin(EaTing), wrote: *In order to preserve transactional atomicity, database-side JDBC procedures that use nested connections have the following limitations. • Cannot issue a commit or rollback, unless called within a CALL statement. • Cannot change connection attributes such as auto-commit. *

Transaction Problems of a Derby Stored Procedure

2008-02-14 Thread sin(EaTing),
Hi, I am writing some stored procedure for Derby. And I am confused about the transaction settings for a Derby stored procedure using a nested connection. Actually I am trying to modify the transaction isolation level to something like Serializable or Read Committed, and also change the auto commit