TOracleSessionPool code example

[ND]

Could you please provide a sample code of how to implement TOracleSessionPool. I was unable to find any code that demonstrates the concept.

I am trying to create a pool of homogeneous, oracle sessions and load it upon startup of the application. When a user session needs to access the database, I would assign available oracle session, from the pool, to the TOracleQuery/TOracleDataSet.

I am not sure if I have to create the TOracleSessions and then associate with SessionPool (global session pool) or use SessionPool to do that. Do I maintain my own list of TOracleSessions or does the SessionPool do that.

It would extremely helpfull if you can provide an example.

 

[Marco Kalter]

There is no real code involved. You will have to explicitly create and manage your TOracleSession instances at design-time or run-time. They can be assigned to the global pool by setting TOracleSession.Pooling to spInternal, or create a specific TOracleSessionPool and assign it to TOracleSession.Pool.

 

[Joseph]

I have the same problem and would like to know if you were able to resolve it. Could you share what you did, if you have them?