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.
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."