Subject Re: [IBO] Need some help
Author mp527 <mp527@yahoo.com>
Yep,
I am creating a new instance of the datamodule everytime I need to
access the db in the thread.
I don't create one per thread because the thread may be connected
for many hours at a time.
Basicly if a command comes in to the server and it needs db access
then I create a new instance of the DM and free it when done.
Each DM has it's own session, cursor, connection and transaction
component.

Tony

> Hi,
>
> are you making sure that each thread has its completely separate
set of
> component instances, including the database connection and the
transaction?
> Not using separate connections can appear to function in a simple
> environment but will fail when threads are actually doing
something in
> parallel.
>
> Cheers,
> Tobias