RE: [DUG] BDE and threads

[Kyley Harris]

Title: Message

each thread should have its own session object, otherwise if 2 threads use a dataset at the same time off one session you'll get corruption

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stacey Verner
Sent: Monday, 8 December 2003 4:58 p.m.
To: [EMAIL PROTECTED]
Subject: [DUG] BDE and threads

Is it possible to have a bde database connection that can be accessed by multiple threads?

 

e.g.

 

Thread 1:

- Create Object X

  - Connect to database.

Thread 1 dies

 

Thread 2

- Find Object X

  - Run SQL on database

Thread 2 dies

 

Thread 3

- Find Object X

  - Run SQL on database

Thread 4 dies

 

Thread 4

- Find Object X

  - Disconnect from database

  - Destroy X

Thread 4 dies

 

This is a service application which is listening for connections, and performing tasks on databases.

 

I want to keep the database connection between requests because the actions performed by the 2nd and 3rd requests can be within a transaction.

 

Thanks

 

Stacey

 

Stacey Verner             Ph:   +64-9-4154790
Software Developer        Fax:  +64-9-4154791
                          DDI:  +64-9-4154797
CJN Technologies Ltd.     Email: [EMAIL PROTECTED]
PO Box 302-278, North Harbour, Auckland 1330, New Zealand
12 Piermark Drive, North Harbour, Auckland, New Zealand
Visit our website at http://www.cjntech.co.nz/

 

_______________________________________________
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi