ORASession losing connection

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jptdev
Posts: 1
Joined: Mon 12 Sep 2022 14:24

ORASession losing connection

Post by jptdev » Mon 12 Sep 2022 14:34

Hi,
I'm using ODAC 9.4.14 with Delphi XE.
Recently we upgraded from Windows 7 to 10, and Oracle 10g to 19c and now we started facing some problems.

In windows 10, after about 1 hour since the user locked his screen, the ORASession disconnects from Database, then, when the user log in again and perform something, for instance, a Query is open, the OraSession starts a new session on Database and the previous Session remains there in Database Inactive. The network connection still working well.

Before moving to the newest version of ODAC and Delphi I have to make this environment work as it was in Windows 7 with Oracle 10g.

Do you have any hints about what could be happening in this new environment?

Unfortunately I can't change the ORASession to work in "Disconnected Mode".

Post Reply