This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Connection problem - Cable disconnected 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 "Connection problem - Cable disconnected" Watch "Connection problem - Cable disconnected" New topic

Connection problem - Cable disconnected

Leandro Oliveira
Ranch Hand

Joined: Nov 07, 2002
Posts: 298
Hi... I'm developing a batch software. And I have the problem, for example, if somebody removes the net cable the application notices that the connection cannot be used (does this with a test like select sysdate from dual) and keeps trying to reconnect. When the cable is plugged, it reconects (creates a new connection) and start it's work. The only problem is that the old connection goes to INACTIVE state, and blocks the new connection when the application creates a new transaction to execute the process. The question is: is there some way to get INACTIVE connections???

Thanks in advance.
Padma Lalwani
Ranch Hand

Joined: Nov 02, 2004
Posts: 49
Maybe you could try to use a connection pool, where the pool would keep a handle to all open connections and close the idle ones after a certain time period

wood burning stoves
subject: Connection problem - Cable disconnected
Similar Threads
Minimum connection pool size 0
Behaviour of InputStream methods during serial transmission.
FTPClient.listFiles() is not working..
TCP ESTABLISHED status even after network cable unplugged