File Lock Problem

["Vijosh A." <vijosh@xxxxxxxxxxxx>]

Hi,

We are developing java based application. The programs access DB2/400 thru
as400JDBC driver. One connection to the database is made at user login. This
connection is used by all calling programs  for accessing data from the
database. I face the following problem  -
                We continously insert/update records into a physical file. 
After a few
records, Insert/Update fails. Now to enter a record we need to exit out of
the whole application.
                'wrkobjlck' on the file shows that for each update/insert a 
shared lock is
made. I tried an explicit commit. But the lock remains. This is what the
wrkobjlck sceen shows -


Opt   Job          User         Lock      Status          Scope     Thread
      QZDASOINIT   QUSER        *SHRRD     HELD           *JOB
                                *SHRRD     HELD           *JOB
                                *SHRRD     HELD           *JOB
                                *SHRRD     HELD           *JOB
                                *SHRRD     HELD           *JOB
                                *SHRRD     HELD           *JOB
                                *SHRRD     HELD           *JOB
                                *SHRRD     HELD           *JOB
                                *SHRRD     HELD           *JOB
                                *SHRRD     HELD           *JOB
                                *SHRRD     HELD           *JOB
                                *SHRRD     HELD           *JOB
                                *SHRRD     HELD           *JOB

Can anybody suggest a solution for this problem.

Thanks


Cheers
Vijosh




>From the Desk of :

Vijosh A.
Senior Consultant
Systems & Software
123, SDF 4, SEEPZ
Andheri (E), Mumbai.

Tel : (91-22) 829 0803/0075
Fax : (91-22) 829 2578


--------------------------------------------------------------
Systems & Software, Mumbai, India
  
     Sent using "The PostMaster" by QuantumLink Communications
   
   One Internet account, unlimited personal e-mail addresses
Get your free copy of "The PostMaster" at http://www.qlcomm.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
+---