Re: no sql-select after sql-update?

["Fred Kulack" <kulack@xxxxxxxxxx>]

Sure.
Repeatable read also means that you're going to be able to read the record
again and get the same values for the rows.
If its locked for update, you can't be allowed to read it or the data you
read may change (depending on whether the transaction that updated
changes the record again, or just does rollback or commit.


In every single ethnic, religious or racial group, there are a
very few truly evil people. For each of those people there
are many, many, many good people.
Assuming anything (evilness or capability for evil) about the
particular group is bigotry and idiocy. Don't do it.  -- Me

Fred A. Kulack  -  AS/400e  Java and Java DB2 access, Jdbc, JTA, etc...
IBM in Rochester, MN  (Phone: 507.253.5982   T/L 553-5982)
mailto:kulack@us.ibm.com   Personal: mailto:kulack@magnaspeed.net
AOL Instant Messenger: Home:FKulack  Work:FKulackWrk


P.Goovaerts@Clipper.Be@midrange.com on 10/12/2001 02:13:05 AM

Please respond to java400-l@midrange.com

Sent by:  java400-l-admin@midrange.com


To:   java400-l@midrange.com
cc:
Subject:  no sql-select after sql-update?



user1 does the following:
1) setTransactionIsolation(4) (repeatable read)
2) setAutoCommit(false)
3) execute 'select' statement to retrieve list
4) execute 'select' statement to retrieve 1 record
5) execute 'update' statement to lock record (dummy update)

user2 does the following:
1) setTransactionIsolation(4) (repeatable read)
2) setAutoCommit(false)
3) execute 'select' statement to retrieve same list
this statement give an exception (lock)

Both user have their own connection/transaction.  I want user 1 to lock the
record for update but user2 should be able to read them...
I understood that TransactionIsolation(4) locks a record when update/delete
without commit()/rollback().  Now it seems that records are lock for
reading also?

_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.