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
Oracle Connection pool in Direct mode
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Oracle Connection pool in Direct mode
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.
Re: Oracle Connection pool in Direct mode
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
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
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Oracle Connection pool in Direct mode
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
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