Send "PING" after a specific idle time

[Bernhard Geyer]

We have found that the IT department of a customer has installed a firewall between our application and the Oracle server.
The firewall is configured to keep the ports stateful so tags can be given to a packet stream. When the packet stream stops (such as with an idle application) the state is changed and then dropped after 60 minutes, causing a Oracle disconnect error.

Can I configure the DOA-Components to send a ping after XX minutes idle-time or must I implement my own "idle-statement"?

Best regards

Bernhard

 

[Marco Kalter]

You will need to implement a little TTimer event. The easiest "Ping equivalent" is to call TOracleSession.CheckConnection, assuming that the application has a connected session.

 

[Bernhard Geyer]

Thank you,

I will try it.