Re: Record locking via JDBC

Jay,

just make a dummy udate to all 4 records at the begin of the transaction.

Dieter

On Mittwoch, 17. März 2004 21:36, Himes, Jay wrote:
> I have a java program that reads and XML document and updates
> 4 tables on our iseries via the ToolBox JDBC driver.
>
> I am having a problem with the program beginning the update
> process, then encountering a record lock after it has already
> updated some fields (it does each field as a separate update
> statement). I would like to be able to lock the record
> that I will be updating in each of the 4 files before
> I update any of them. I do not want to put all of the updates
> in a single transaction as I don't want to roll back the changes
> if there is a failure of one of the updates (which is why the
> program does each field separately).
>
> Is there a way to do this? A "read the manual" response would
> be welcomed especially if you could point out a good starting
> point.
>
> TIA,
> Jay Himes
> Liberty University
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
> mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.

-- 
mfG

Dieter Bender


DV-Beratung Dieter Bender
Wetzlarerstr. 25
35435 Wettenberg
Tel. +49 641 9805855
Fax +49 641 9805856
www.bender-dv.de
eMail dieter.bender@xxxxxxxxxxxx