Multiple Sessions and Transactions

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
JFlo
Posts: 9
Joined: Tue 23 Nov 2004 13:31

Multiple Sessions and Transactions

Post by JFlo » Tue 21 Jun 2005 09:06

In a multi-threaded program i use a session for each thread, cloned from the program's main session with AssignConnect().
As far as i can see now these sessions are not independend. A Commit in one session commits the others too, destroying transactions.

I am quite shure, that this didn't happen in release 5.10

How can i avoid this, since i need savepoints and individual transactions.
Top
Alex
Posts: 655
Joined: Mon 08 Nov 2004 08:39

Post by Alex » Wed 22 Jun 2005 12:47

TOraSession.AssignConnect method share database connection between TOraSession components. You are right that assigned sessions are not independend from base but this is designed behaviour. In your case you need to setup sessions without calling AssignConnect method.
Top
Post Reply

Return to “Oracle Data Access Components”