File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Database exception - java.sql.SQLException: ORA-00054 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Database exception - java.sql.SQLException: ORA-00054" Watch "Database exception - java.sql.SQLException: ORA-00054" New topic

Database exception - java.sql.SQLException: ORA-00054

Venkata Cherukuri

Joined: Sep 07, 2003
Posts: 12
I get the following error -
resource busy and acquire with NOWAIT specified
.]: Received Exception : com.manu.webservices.db.ManuDBException: Database exception - java.sql.SQLException: ORA-00054: resource busy and acquire with NOWAIT specified

What is the cause of it. I get my connection in a local method, and return it to the pool after using it.

Tnks in advance
Shankar Narayana
Ranch Hand

Joined: Jan 08, 2003
Posts: 134
Hi Venkat,

I dont really know what do to in oracle for this type of error, but i am using MySql4.0 and in my client, i can see some variables like Table_locks_waited,Table_locks_immediate, wait_timeout. May be you should try to find corressponding variables to set, so that your query waits for certain time to get back the results.

"Failure is not when you fall down; its only when you fail to get up again."
I agree. Here's the link:
subject: Database exception - java.sql.SQLException: ORA-00054
It's not a secret anymore!