Single Oracle Session

[Adriano]

I am completely new to DOA so forgive me if my question is too basic !

My puzzle is: Delphi 5.01 to make a front-end and middle-tier of a multi-tiered application, Oracle 8.1.7 (client & server) and DOA Version 3.4.6 for Delphi 5.

When using BDE I made a Remote Data Module that is Multi Instance and Apartment Threading model. This RDM is responsible for establishing a single connection to Oracle that is shared by all the Clients (with some restrictions, of course). I intend to do the same with DOA. I read the help and found that setting the TOracleSession.ThreadSafe property to true achieves this result. But I did it and checking Oracle I found one Session for each Client I had opened.

What am I doing wrong ? TIA.

 

[Marco Kalter]

The ThreadSafe property will only make sure that access to this session by multiple threads is serialized.

I don't think this is any different than with the BDE.

------------------
Marco Kalter
Allround Automations

 

[Adriano]

In fact it should act like BDE, but does not.
In BDE I can use a TSession object with the "AutoSessionName" set to true, if I want o open one Oracle connection to each client.
But I do not use the TSession, so I open only one Oracle connection that is shared by all the Clients.
I suppose it can be done in DOA, doesn't it ?

 

[Marco Kalter]

Doesn't AutoSessionName merely guarantee that a session has a unique name? For a TOracleSession this is not relevant, since it does not have a SessionName.

------------------
Marco Kalter
Allround Automations

 

[Adriano]

OK ! Forget everything I said before.
My question is: What exactly should I do in order to make a multi-tiered application where the application server opens only one Session to Oracle and this session can be shared for all the connected clients.