Oracle disconnect

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Sec
Posts: 1
Joined: Tue 14 Jun 2022 06:50

Oracle disconnect

Post by Sec » Tue 14 Jun 2022 08:29

Hello,

I have an application that is pooling a table in oracle from delphi (odac) every second. After a time, in some cases 20 minutes in other 50 minutes, the procedure can't be executed due to the connection lose and this app should be running 24/7. To solve this situation every 10 minutes I disconnect from the ddbb and connect again. My questions are:

Is this something related to the session time in oracle or the ODAC component?
Which would be "the best way" to "keep alive" the connection?

Thanks in advance.

PD: I have seen many answers related to the orasession, reconections etc, but ...
Top
Post Reply

Return to “Oracle Data Access Components”