DOA CheckConnection

[danilo.casa]

Hi, we are encountering problems by using this function, maybe deadlocks...
And also with reconnect = false.
Anyone experiencing this kind of problems?

Can you tell us what exactly does this function?

Thanks in advance..

 

[Marco Kalter]

The function first tries a dummy statement (select null from dual) to check if the session is still alive. If it's alive, it returns ccOK. If it's not alive it will try to connect again. If that succeeds it returns ccReconnected. If it fails it returns ccError.

 

[danilo.casa]

Hi, and thank you very much for the quick reply!
We'll check our code..
Only a few questions:
1. if the session isn't alive, does the function try to reconnect it even if the "Reconnect" parameter is set to False?
2. Having set the TOracleSession.ThreadSafe property to True, can we make use of CheckConnection without problems in a multi-threaded environment where multiple threads access the ToracleSession object simultaneously?

TIA!
Regards,

 

[Marco Kalter]

1. if the session isn't alive, does the function try to reconnect it even if the "Reconnect" parameter is set to False?

No.

2. Having set the TOracleSession.ThreadSafe property to True, can we make use of CheckConnection without problems in a multi-threaded environment where multiple threads access the ToracleSession object simultaneously?

No, the CheckConnection function will be blocked by any activity that is currently taking place for the session.

 

[danilo.casa]

Ok, thank you for your answer!
Best regards,