session commit problem

M

manas

Member²
Dear Sir,

I use CacheUpdate,Delphi 6 SP2, and DOA 3.4.6.

Sometimes even I commit with the below code,
my record remains closed and commit does not work.

------------------------------------
session.ApplyUpdates([self],false);
Session.CommitUpdates([Self]);
Session.Commit;
------------------------------------

This usually happens when there is slow connection to remote server through WAN.

Is this problem solved with 3.6.4?

Best regards,
Yusuf
 
This should work just fine, I have no problem reports in this area. The last commit is not even necessary, because TOracleSession.CommitUpdates implicitly commits.

If this fails, there must be some Oracle exception somewhere. If the problem is reproducible, you can use the OracleMonitor utility to check what goes wrong.

------------------
Marco Kalter
Allround Automations
 
You must log in or register to reply here.
Back
Top