Devart Forums

Hello!

I'm using oracle 9, and ODAC 6.70.0.44 on D7. AutoCommit in the applications is set to true;

My problem is, that after version upgrade (about 3 month ago) from 5.70 to newer, sometimes data from my application are not visible until Application close.

I have the same projects (5 cooperating application). Users setting the data by inserting or upgrading records and another user are reading it (in same time) on other application, on other computer.
Since ODAC version upgrade and recompiling all projects, sometimes in some application data are set, but not visible on other applications. Only switching off (setting data) application release datas, and since this time the datas are visible on other applications.

The situation appear one or twice by day, about 10 sql.upgrade/insert queries by about 700.

We could not reproduce the problem. Please send to odac*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.

As I said, the situation happen occasional, so (even though I tried) I can not to make a sample you want.
During my investigation, I have noticed, that the problem is with AutoCommit, becouse even though it is set to true, when the problem has occur, I can make OraSession.Commit, to solve the problem.

So... Can you check, is there any way to (even though autoCommit= true) a transaction is not commited?

regards
Mariusz

We have checked it but could not reproduce the problem.

I've the same situation my self. sometimes with OraSession.Autocommit = True, the application commit the data when the application is close.
My clients lose data ... and this is not good. I am planning to regturn to 6.20 version where there is no problem.

What should I do ?

I am using D7 + Oracle 10G XE

To ionutop2007:
Please send to odac*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.