Re: updatable ResultSets

[Dieter Bender <dieter.bender@xxxxxxxxxxxx>]

Hi,

its locked, but allows shre read and might run in conflict with another 
transaction trying the same thing. you get a higher lock with a pseudo update 
under commit
update ... set somefield = somefield where ...

Dieter Bender

On Mittwoch, 14. Januar 2004 17:36, Glenn Holmer wrote:
> This question is about code that runs on an AS/400 in a program
> that acts as an RMI server.  The method is not synchronized.
> With this code:
>
> stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
>                             ResultSet.CONCUR_UPDATABLE);
> sqlStmt = "SELECT WIPNO, LOWEST, HIGHEST "
>         + "FROM WMSLIB.SERIALNO "
>         + "WHERE WIPNO = '" + wipNo + "' FOR UPDATE";
> rs = stmt.executeQuery(sqlStmt);
>
> am I guaranteed (by using "FOR UPDATE") that the record I read
> will be locked until it is either written back or the result set
> is closed?  If not, how can I achieve this?

-- 
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