Page 1 of 1

Savepoint problem

Posted: Tue 26 Jan 2010 14:15
by scw2hi
Hi,

I´m using ODACs 6.90.0.54 with RAD Studio 2010 (C++)

Code: Select all

main->ora_session->StartTransaction();

otb_data->Edit();

This creates a savepoint named "LOCK_otb_data"

Then I change some data related to the currently locked entry
In previous version I was able to overwrite the savepoint "LOCK_otb_data"
My problem now this does not work any longer and posting the original edited object rolls back to savepoint.
Afterwards my edits are gone.

Can you help?!

more problems?

Posted: Tue 26 Jan 2010 15:56
by scw2hi
Each new ora_session->Savepoint("Test")
creates a new Savepoint entry in DBMonitor but without any name!

So a new savepoint seem to overwrite the previous one without careing about its name

Posted: Wed 27 Jan 2010 06:31
by kurtbilde
Hi,

Looks like the issue I stumbled upon in august... (Search for Ora-1086 error). The problem was never found by Devart, even though ODAC did create it's own errormessage dialog. Does it raise an ORA-error or ?!?

All the best
Kurt

it is different

Posted: Wed 27 Jan 2010 07:10
by scw2hi
Hi,

I haven´t seen any ORA error message so far.

The only thing I can see is that all manually created savepoints are sored on ora_session without any name.

Posted: Thu 28 Jan 2010 13:31
by Plash
We have fixed this problem. The fix will be included in the next build of ODAC.

Good news

Posted: Thu 28 Jan 2010 13:34
by scw2hi
That is great :D ,

thanks in advance