Subject | Re: [IBO] Need some help |
---|---|
Author | mp527 <mp527@yahoo.com> |
Post date | 2003-01-09T19:31:42Z |
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
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,set of
>
> are you making sure that each thread has its completely separate
> component instances, including the database connection and thetransaction?
> Not using separate connections can appear to function in a simplesomething in
> environment but will fail when threads are actually doing
> parallel.
>
> Cheers,
> Tobias