× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



On 10/12/2001 at 09:02:09 AM, java400-l-admin@midrange.com wrote:
Please read mail 'URGENT please : Locked records'  also.

The record is available when using 'select...' statement when I execute the
methods from within VAJAVA, not when executed from webapp...
The intention is to 'lock' for updating only!
--- end of excerpt ---

I don't save email from java400-l so can't look back in history.
Is there an archive somewhere?

Not too sure how to answer this one...
Lets see if I can try a couple things and hit the mark...


If you've got a row locked for update, and the isolation level
of the reader says that you _don't_ want to get data that could
possibly change or be out of date (repeatable_read), then you're
simply not going to be able to read it.


Perhaps you want to make the reader run with a lower isolation level
(read_uncomitted) because it sounds like it can tolerate reading
'out of date' data? i.e. rows that the other guy has locked for
update (or has actually updated already that may roll back) .


However, perhaps you want the updater to run with a higher isolation level
(repeatable read) because it will be the one reading, then later
updating the row. It wouldn't want anyone to be mucking with the row
between the read and the update of that row.

1) do the query with statement 1
2) fetch/read the row
blah blah blah .... processing
3) update the row





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



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.