?
Solved

ORACLE -- JBO-26030 failed to lock

Posted on 2009-12-21
4
Medium Priority
?
1,802 Views
Last Modified: 2013-12-18
What ORACLE command can I run to see what locks are
  ** JBO-26030 failed to lock the record another user holds the lock ?

Also, how can I force kill the lock ?
0
Comment
Question by:finance_teacher
  • 3
4 Comments
 
LVL 7

Expert Comment

by:ppinon
ID: 26097006
select * from v$lock

or

select l1.sid, ' IS BLOCKING ', l2.sid
    from v$lock l1, v$lock l2
    where l1.block =1 and l2.request > 0
    and l1.id1=l2.id1
    and l1.id2=l2.id2
0
 
LVL 7

Expert Comment

by:ppinon
ID: 26097014
and with the sid provided with the second query you can do a

ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;
0
 

Author Comment

by:finance_teacher
ID: 26133452
Still fails

Steps I did:
 1. open TOAD
 2. edit a record
 3. don't commit
 4. open JDev APP
 5. change record
 6. try to commit
 7. get attached error
-------------------------------------------------------
select * from v$lock
  ** shows everything
-------------------------------------------------------
select l1.sid, ' IS BLOCKING ', l2.sid
    from v$lock l1, v$lock l2
    where l1.block =1 and l2.request > 0
    and l1.id1=l2.id1
    and l1.id2=l2.id2
  ** shows nothing
0001.jpg
0
 
LVL 7

Accepted Solution

by:
ppinon earned 2000 total points
ID: 26341196
Try using Optimistic locking, setting the parameter jbo.locking.mode to “optimistic”. Then rebuild your application.

See http://www.oracle.com/technology/products/jdev/howtos/10g/bcstate/index.html
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question