aspose file tools*
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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Database exception - java.sql.SQLException: ORA-00054" Watch "Database exception - java.sql.SQLException: ORA-00054" New topic
Author

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

Venkata Cherukuri
Greenhorn

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: http://aspose.com/file-tools
 
subject: Database exception - java.sql.SQLException: ORA-00054