| 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."
|
|
 |
|
|
subject: Database exception - java.sql.SQLException: ORA-00054
|
|
|
0
