[Mono-dev] SqlConnection Pooling Problem?

[A Nagappan]

Hi,

Could you please file a bug on this with a sample test case to reproduce
this bug.

http://bugzilla.ximian.com/enter_bug.cgi?product=Mono%3A%20Class%20Libraries
under Sys.Data.SqlClient component.

Thanks
Nagappan

Nagappan A <anagappan at novell.com>
Linux Desktop Testing Project - http://ldtp.freedesktop.org
http://nagappanal.blogspot.com

Novell, Inc.
SUSE® Linux Enterprise 10
Your Linux is ready™
http://www.novell.com/linux


>>> Tony Gu <tonyxgu at yahoo.com> 03/02/07 1:12 AM >>>
Actually, this problem started from mono-1.2.1. It is OK on mono-1.2. I
just tested same application on those.


----- Original Message ----
From: Tony Gu <tonyxgu at yahoo.com>
To: Mono Development List <mono-devel-list at lists.ximian.com>
Sent: Thursday, March 1, 2007 10:09:15 AM
Subject: [Mono-dev] SqlConnection Pooling Problem?


I got problem to use SqlConnection in mono-1.2.3.1 (seems on pooling).
It hangs on creating new SqlConnection(connectionString) if the "Min
Pool Size" greater than 0.
Here is my connectionStrings:
<connectionStrings>
<add name="DefaultDb" connectionString="Data Source=MYDBSITE\DBSERVER;
User Id=superuser; Password=mypasswd; Max Pool Size=15; Min Pool
Size=3;Pooling=yes;" providerName="System.Data.SqlClient"/>
</connectionStrings>
If I change the "Min Pool Size" as "0", it can create the connection
well, but only works the queries before close this connection
(connection.Close()). The next time to use this connection (it is not
null) will get the Exception "SQL Server does not exist or access
denied.". If I restart the application it will execute the first (set)
query(s). After close and reopen the connection, got same error.
The same web application runs OK on the early vewrsion(mono-1.1.18)
without the "Pool Size" in the Web.Config. If I take the "Pool Size" off
the config, the behave is same as "Min Pool Size=0".
Does anybody experience this problem?
 
Tony
 



Get your own web address.
Have a HUGE year through Yahoo! Small Business. 
_______________________________________________
Mono-devel-list mailing list
Mono-devel-list at lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-devel-list


 
____________________________________________________________________________________
8:00? 8:25? 8:40? Find a flick in no time 
with the Yahoo! Search movie showtime shortcut.
http://tools.search.yahoo.com/shortcuts/#news