On Oct 07, 2006, at 12:20 PM, Narinder Chandi wrote:
Dear All,
Can someone point out where I'm going wrong? I have a list of records
displayed in a list box from which I can double click to open
records for
editing in a new window. Each window is opened in its own thread and I
explicitly start a transaction. For the first record opened its OK,
but when
trying to open a second record (in a new thread in a new window) I
get this
error :
"Cannot start a transaction within a transaction"
I don't understand why.
No nested transaction support.
Surely it must be possible to open multiple
simultaneous transactions, especially if they're running in their own
threads?
You have to make sure that you have a separate connection for each in
each thread.
Oobviously I have a single globally accessible connection to the
database
open and I'm wondering if that's the issue. I'm not to keen on
opening and
closing lots of separate connections as it seems wasteful and may
affect
performance.
It is
You require a separate connection for each
Note that I get the exact same problem if am adding 2 new records
i.e. the
error occurs on an attempt to start adding the second record whilst
the
first one is still open).
Finally, if I remove the explicit request to start a transaction
then I get
no error, but this is of no practical use.
Regards,
Narinder.
--
___________________________________________
| Narinder Chandi,
| ToolBox Systems Limited,
| Surrey, England, UK.
| http://www.toolbox.uk.com
|___________________________________________
| Consultancy * Development * Support
|___________________________________________
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
Norman Palardy
OS X 10.4.8 / MacBook Pro 2.16Ghz MHz / 2Gb RAM
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
