Pooling

[gcardona]

Hello group, I have the next question:

I was checking the ODAC example:

\Demos\Miscellaneous\FailOver

I can see that option pooling are enable by parameters but I do not understand very well how can get each query get an session for the pool.

If I have some queries the only thing that I need to do, is link the TOraQuery with Session?

Will ODAC assign the session from the pool to a new query? if the default connection is busy.

Best regards,

Gustavo

[Plash]

ODAC does not assign sessions from the pool to queries. Regardless of TOraSesion.Pooling property, all queries use the same session from their TOraSession component. If this session is busy, a query will not be executed until the session become free.

Pooling is not intended to execute queries in parallel. It is intended to improve performance of TOraSession.Connect method as I have wrote you in my last mail.

[gcardona]

In Pooling mode one session is created for one TOraSession component just as in normal mode. Pooling is intended to decrease connection time and minimize resources usage in application that has many TOraSession components with the same parameters (Server, Username, Password). When one TOraSession component disconnects, its session is not closed but it is placed to pool. When another TOraSession component connects it can take a session from the pool.

You are right, you told me that...

I apologize to ask two times...

Best regards and thanks for your help.

Gustavo

[gcardona]

Hello Plash, how can I ask if the connection is busy?

Best regards,

Gustavo

[jfudickar]

You can't

See my request here : http://crlab.com/forums/viewtopic.php?t=11023

Hopefully they will implement it in the not so far future.

Greetings
Jens