Re: File Lock Problem -- JAVA400-L

Typically, closure of all Statements, Resultsets and
releasing connections should definitely release any
"locking". So examine the code and ensure it is done.
This was my experience.



--- "Vijosh A." <vijosh@systsoft.com> wrote:
> 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
> +---


__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
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
+---