• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection problem - Cable disconnected

 
Leandro Oliveira
Ranch Hand
Posts: 298
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 49
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

Padma
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic