Page 1 of 1

DirectMode Connecting Pooling

Posted: Wed 27 Apr 2011 17:54
by kevin.weir
We are using version 6.10.121 of dotConnect for Oracle that targets Oracle 10.2.0.4.

The following connection string is used in a Windows Form application:
User Id=USER;Password=PASSWORD;Server=DATABASE;Service Name=DATABASE;Direct=True;Pooling=true;min pool size=25;max pool size=125;

The problem we are having is 25 connections are created for each client that runs. Am I missing something? Isn't the whole point of connection pooling to share the connections among all the clients?

Kevin

Posted: Thu 28 Apr 2011 14:48
by Shalex
Connection pool created by ADO.NET provider exists in the scope of current application domain: http://msdn.microsoft.com/ru-ru/library ... 85%29.aspx.
If you want to implement server-side connection pooling, please take a look at Oracle Database Resident Connection Pooling (DRCP). This feature is implemented in Oracle server 11g and supported by dotConnect for Oracle (available only in the OCI mode) starting from the 6.10.96 version.

Posted: Fri 29 Apr 2011 16:56
by kevin.weir
Thanks for quick reply. That was helpful.