This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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 REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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...
It's not a secret anymore!