Oracle Connection pool in Direct mode

[saschab]

Hello together,

i've a multithreading c# application that needs a connection pool. Is there a way to implemet this when using dot connect for oracle in direct mode? Or have I to implement it somehow by my own?

Best Regards
Sascha

[Pinturiccio]

dotConnect for Oracle supports the connection pool in the Direct mode. So you can use the connection pool in a multi-threaded application in the Direct mode.

[saschab]

Hi,

thx for the reply can you give me a small example how to implement it? At the moment I've set the maxpoolsize to 150 and do a OracleConnection = new Oracleconnection with the connection string from the ConnectionStringBuilder class in the threads.
Is this the right way to use connection pooling in direct mode?

Best Regards Sascha

[Pinturiccio]

You have to set the Pooling connection string parameter to 'True'. By default, if not specified explicitly, the Pooling parameter value is equal to 'True'.

Another way is to initialize the connection via the OracleConnectionStringBuilder class object. This object has the Pooling property. Set the value of this property to 'True' and for the connection initialized by this object, Connection pool will be used.

For more information, please refer to
http://www.devart.com/dotconnect/oracle ... tring.html
http://www.devart.com/dotconnect/oracle ... oling.html