connection lost

[saitsari]

hi,
we moved our project from delphi 7, 5.5 odac to delphi xe, odac 8.1.4.
But we get error on customer site.
1.Readonly Toraquery(No update,insert,delete sql) return to updateable query.
we solve problem with OraQueryCompatibilityMode:=True;

2.Connection is lost at any time not specified work.
For example customer enter system (connection is established) but connection is lost when customer is working (sometime 1 hour later, sometiemes 10 minustes later). After that program crashed and halt.
in this case we open option/failover=true
Normal connection lost is reestablished but mostly not.

3.Dblookup keyvalue is lost when query is filtered or another datasource is binding. in this case keyvalue return to null.

Note:Connection lost problem seen on paltform (xp, vista, 7) but especialyy xp pro, update 3

best regards,

[AlexP]

hello,

1) In earlier versions of ODAC, the update,insert,delete,refresh queries wasn't formed automatically. Presently, such queries are formed automatically, therefore, we have really included the QueryCompatibilityMode global variable for compatibility with old ODAC versions.
2) Try to set the RetryMode var parameter in the OraSession.onConnectionLost event to rmReconnect or rmReconnectExecute depending on the behaviour you need (more detailed info about this event is available in the TCustomDAConnection.OnConnectionLost Event section of the help).
3) We cannot reproduce the described problem, please send a small sample demonstrating the problem to alexp*devart*com

[saitsari]

hi,
I received following error after upgrage to 8.1.4 (Same problem occur on delphi xe or delphi 7).

ORA-24909: call in progress. Current operation cancelled
ORA-03106: fatal two-task communication protocol error
ORA-03113: end-of-file on communication channel
ORA-24338:
I found an Explanation for these errors at link https://forums.oracle.com/forums/thread ... dID=659137.

I will try this solution. But we have 350 customers.

Also why do we get these error on new version, not on oldest version?

best regards

[AlexP]

Hello,

There was made a lot of changes between ODAC versions 5.5 and 8.1, therefore we cannot define the reason of the different behaviour of these versions without a sample reproducing the problem or description of steps for reproducing it.

P.S. If the problem is really due to the server itself, and the error that occurs when using ODAC - to additional features that affect problems fixed in the patch you mentioned, most probably, you will have to install updates for the server.

[saitsari]

hi,
connection lost and error on previous messeages occurs in case server versiyon and client version is different.
for example: server :10.2.x and client 10.1.x , user get this error during working at any time (30 min, or 1 hour etc ), Not at connection time.
Also mostly seen in users that use CLOB/BLOB fields.

if user install same versiyon, there is no problem. But there is no problem with old version at same configuration (Server 10.2.x client 10.1x or 9.x etc).

best regards,
not : correct link https://forums.oracle.com/forums/thread ... dID=659137

[AlexP]

Hello,

Perhaps the changes made between these ODAC versions cause problems when operating in the failover mode, however, we were not able to reproduce this problem. To fix this problem we need an example and description of the steps demonstrating the problem, if you happen to create a small example , please send it to info*devart*com and we will try to deal with the causes of this problem in the latest versions of ODAC