my dog learned polymorphism*
The moose likes JDBC and the fly likes Reconnecting to Oracle... 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 "Reconnecting to Oracle..." Watch "Reconnecting to Oracle..." New topic

Reconnecting to Oracle...

Jaffer Shah

Joined: Oct 16, 2003
Posts: 6

Our application is a data processing one that depends on Oracle. We commit the connection only when all the processing is correct, else rollback. When there is some failure in the network connectivity, we try to connect to Oracle again and start the data processing again. But whats happeneing is different. When we try to reconnect to oracle, we are able to get the connection, but cannot be able to perform any insert operations. The application just hangs when it tries to insert into the table (may be the table is locked). Kindly suggest us a way to proceed with.

Thanks in advance.
I agree. Here's the link:
subject: Reconnecting to Oracle...
Similar Threads
How to store & retrieve a video file from database?
JDBC start/stop database needed
Io Exception : Broken Pipe
web application concurrent access
ORA-01000: maximum open cursors exceeded