aspose file tools*
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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Reconnecting to Oracle..." Watch "Reconnecting to Oracle..." New topic
Author

Reconnecting to Oracle...

Jaffer Shah
Greenhorn

Joined: Oct 16, 2003
Posts: 6
Hi,

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: http://aspose.com/file-tools
 
subject: Reconnecting to Oracle...