Shane Sturgeon wrote:

> Thanks Yusuf
>
> I think I have a sense of what you are doing now. The iConnection
> interface is what was missing in my understanding. I take it that has
> database and session properties or do you just ask it for an EDBQuery
> instance, and leave the setup of that to the 'black box' of the
> interface?
>
> Cheers
> Shane

The most important line is this:

vmyCONN:=dm.rootdb.GetDatabaseConnectionfromPool();

dm.rootdb is my Database-Session to ElevateDB Server.

Calling GetDatabaseConnectionfromPool creates a "Clone" of the current
Database Session including DatabaseConnection and gives it back. having
it as interface makes the "Pool" self managed in my case. So i can ask
for a iConnection to use it in a thread and if thread finishes the
iConnection is not used any more and can be used for another call or
disconnects itself within a defined interval.

Thanks Yusuf.

Just double checking - you mention clone? Wouldn't you need a distinct EDBSession in order to be thread safe, or have I misunderstood something?


"Yusuf Zorlu" wrote:

The most important line is this:

vmyCONN:=dm.rootdb.GetDatabaseConnectionfromPool();

dm.rootdb is my Database-Session to ElevateDB Server.

Calling GetDatabaseConnectionfromPool creates a "Clone" of the current
Database Session including DatabaseConnection and gives it back. having
it as interface makes the "Pool" self managed in my case. So i can ask
for a iConnection to use it in a thread and if thread finishes the
iConnection is not used any more and can be used for another call or
disconnects itself within a defined interval.

Shane Sturgeon wrote:

> Thanks Yusuf.
>
> Just double checking - you mention clone? Wouldn't you need a
> distinct EDBSession in order to be thread safe, or have I
> misunderstood something?
>
>
> "Yusuf Zorlu" wrote:
>
> The most important line is this:
>
> vmyCONN:=dm.rootdb.GetDatabaseConnectionfromPool();
>
> dm.rootdb is my Database-Session to ElevateDB Server.
>
> Calling GetDatabaseConnectionfromPool creates a "Clone" of the current
> Database Session including DatabaseConnection and gives it back.
> having it as interface makes the "Pool" self managed in my case. So i
> can ask for a iConnection to use it in a thread and if thread
> finishes the iConnection is not used any more and can be used for
> another call or disconnects itself within a defined interval.

A clone is nothing more than new session and db component with settings
copied from master

Thanks Yusuf - Got it now

Cheers
Shane