Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Internal Exception: java.sql.SQLException: ORA-30006: resource busy; acquir

694869Jan 5 2012 — edited Jan 5 2012

Hi,

[TopLink Warning]: 2011.12.29 07:54:49.481--SessionBroker(398156694)--Exception [TOPLINK-4002] (Oracle TopLink - 10g Release 3 (10.1.3.5.0) (Build 090715)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-30006: resource busy; acquire with WAIT timeout expired
Error Code: 30006
Call:select XMLCast(XMLQuery('declare default element namespace ''http://com.name.schema.proj.Purchase''; (: :) /PurchaseOrder/ObjectID' PASSING A.Purchase_Order_xml RETURNING CONTENT) AS NUMBER) from PurchaseOrder A where XMLCast(XMLQuery('declare default element namespace ''http://com.name.schema.proj.Purchase''; (: :) /PurchaseOrder/ObjectID' PASSING A.Purchase_Order_xml RETURNING CONTENT) AS NUMBER) = 100000000291770 for update wait 60

Here is the DB information

--------------------------------------------------------------------------------
BANNER

--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

JDBC Driver is 10.1.0.5.0 (ojdbc14.jar)
java version "1.5.0_06"

Any advise?

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 2 2012

Added on Jan 5 2012

#performance-availability, #xml-db

3 comments

1,417 views