DirectMode Connecting Pooling

DirectMode Connecting Pooling

Postby kevin.weir » Wed 27 Apr 2011 17:54

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
kevin.weir
 
Posts: 12
Joined: Wed 17 Sep 2008 22:25

Postby Shalex » Thu 28 Apr 2011 14:48

Connection pool created by ADO.NET provider exists in the scope of current application domain: http://msdn.microsoft.com/ru-ru/library/8xx3tyca%28v=VS.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.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Postby kevin.weir » Fri 29 Apr 2011 16:56

Thanks for quick reply. That was helpful.
kevin.weir
 
Posts: 12
Joined: Wed 17 Sep 2008 22:25


Return to dotConnect for Oracle