• Post Reply Bookmark Topic Watch Topic
  • New Topic

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

 
Venkata Cherukuri
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 134
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!