Page 1 of 1

Multiple Sessions and Transactions

Posted: Tue 21 Jun 2005 09:06
by JFlo
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.

Posted: Wed 22 Jun 2005 12:47
by Alex
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.