Idle-State

[paschwan]

Hello

we're geting problems with our firewall, which disconnects our connection when it is Idle for a certain time. I can now avoid that by permanently sending (eg. every 10min) a dummy request just to keep the connection alive.
However I don't want to do this forever - say eg. after 4h Idle-Time, the connection should be closed anyway.
How can this Idle-State be monitored ? I already looked everywhere in the TOracleSession without success.

Thanks, Patrick

 

[Marco Kalter]

There is no explicit support for monitoring idle time. You could use the LogActivity event (see LogActivity.pdf in the Doc subdirectory) to reset an idle timer. This event fires for each database activity.