JDBC lock after update

[shahar mor <shahar_mor@xxxxxxxxx>]

Hi all,

I have an application that uses the toolbox jdbc
driver to connect to the as400 database.

When doing select for update, and rs.next i can clear
all locks obtained by QZDASOINIT server job by closing
the result set (rs.close).

When i update a row by using 'update f set fld=value
where keyfld=unique value' the row is updated but the
QZDASOINIT retain a read lock on the updated record.

Is there a way to get rid of the read lock which
remains after the update ?

Thanks for any input


=====
Shahar mor
consultant
__________________________________________________
Do You Yahoo!?
Thousands of Stores.  Millions of Products.  All in one place.
Yahoo! Shopping: http://shopping.yahoo.com
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---