AutoCommit = true, but data visible after application close!

mariusz · Post by **mariusz** » Mon 16 Feb 2009 14:28

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.

Plash · Post by **Plash** » Fri 20 Feb 2009 09:16

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.

mariusz · Post by **mariusz** » Fri 06 Mar 2009 16:15

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

Plash · Post by **Plash** » Wed 11 Mar 2009 08:36

We have checked it but could not reproduce the problem.

ionutop2007 · Post by **ionutop2007** » Thu 19 Mar 2009 14:36

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

Plash · Post by **Plash** » Fri 20 Mar 2009 09:06

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