TOraSession and ConnectionTimeout

[Daniele Buttarelli]

I have problems with the ConnectionTimeout property of TOraSession using DirectMode.
I'm testing the connection on a IPAD, via 3G + VPN.
I set the timeout to 10 seconds, but when 3G connection drops, OraSession takes several minutes before it comes out the error ORA-03113 (end-of-file on communication channel).
How can I solve this problem?
I'm using ODAC 9.0.2 with Delphi XE4 Update 1.
Thanks to all!
Daniele

[AlexP]

Hello,

Unfortunately, we cannot reproduce the problem on 3G + VPN, we checked this behaviour on Wi-Fi. Please test the behaviour using Wi-Fi, since the problem may be due to the 3G specificity.

[Daniele Buttarelli]

The problem occurs even if I disconnect only the VPN.
I'll try via Wifi.

[Daniele Buttarelli]

I tried via wifi but the problem still remains.
OraSession takes too much time than the ConnectionTimeout.
Here are my settings:
object OraSession: TOraSession
Options.OptimizerMode = omRule
Options.ConnectionTimeout = 10
Options.Direct = True
LoginPrompt = False
OnError = OraSessionError
end

[AlexP]

Hello,

Please describe the steps leading to the problem occurrence

[Daniele Buttarelli]

1) I start Wifi or 3G+VPN on my Ipad;
2) I execute my app that connect OraSession to an Oracle 11g Database;
3) I open an OraQuery (FetchRows=20; FetchAll=False);
Ah this point everything working properly!
4) I disconnect VPN or stop Wifi;
5) I try to execute another OraQuery;
At this point I have to wait some seconds, sometimes even minutes...;
6) Exception ORA-03113 (event OraSession.OnError invoked);

[AlexP]

Hello,

Thank you for the information, we have reproduced and fixed the problem, this fix will be included in the next build.

[Daniele Buttarelli]

When the new version will be available?
Thanks.
Best regards.
Daniele

[AndreyZ]

We plan to release ODAC this month.