This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC 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

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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
Similar Threads
JPOX, Oracle and a whole lotta waiting
WebSphere community edition Database Pools connection problem
How to set connection timeout on lcoked record?
Problem inserting Blob into Oracle DB
Compiling SQL statement before execute