Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / ASP.NET / General / December 2007

Tip: Looking for answers? Try searching our database.

EntLib for .NET 2.0 - January 2006 and MySQL

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
rockdale - 26 Dec 2007 20:58 GMT
Hi, all:

My web application using MS EntLib for .net 2.0 (Jan 2006) to access
my backend database. It works fine with MS SQL 2k. Now we are migrate
from MS SQL to mySQL. Everything looks fine except one serious
problem:  we got the "too many connections" error. Looks like the
EntLib did not properly close these connections.

on mySQL Administrator> server connections> Threads I can see a new
thread created after a couple of DatabaseFactory.CreateDatabase()
functions being called;

I am suppose that the EntLib will close the connectons and return it
back to connection pool?

my database access function looks like:

Database db = DatabaseFactory.CreateDatabase();
define DBcommand
execute command  (db.ExecuteScalar, db.ExecuteDataSet or
db.ExecuteReader)

Am I miss anything? Help please.

Thanks in advance
-rockdale
rockdale - 26 Dec 2007 21:21 GMT
This is the error message and trace info:

This happens even I kill all connections:

Exception Details: MySql.Data.MySqlClient.MySqlException: error
connecting: Timeout expired.  The timeout period elapsed prior to
obtaining a connection from the pool.  This may have occurred because
all pooled connections were in use and max pool size was reached.

Stack Trace:

[MySqlException (0x80004005): error connecting: Timeout expired.  The
timeout period elapsed prior to obtaining a connection from the pool.
This may have occurred because all pooled connections were in use and
max pool size was reached.]
  MySql.Data.MySqlClient.MySqlPool.GetConnection() +124
  MySql.Data.MySqlClient.MySqlConnection.Open() +223

Microsoft.Practices.EnterpriseLibrary.Data.Database.OpenConnection()
in C:\WorkSpace\Microsoft Enterprise Library January 2006\src\Data
\Database.cs:1222

Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteScalar(DbCommand
command) in C:\WorkSpace\Microsoft Enterprise Library January 2006\src
\Data\Database.cs:588
  DataAccess.UserLogin(String pLoginId, String pPwd, String
pUserHost) +105
  Pages_Login.ButtonLogin_OnClick(Object sender, EventArgs e) +111
  System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs
e) +105
  System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String
eventArgument) +115

System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +7
  System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +11
  System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
+33
  System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
+5102

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42;
ASP.NET Version:2.0.50727.42

> Hi, all:
>
[quoted text clipped - 22 lines]
> Thanks in advance
> -rockdale
sloan - 27 Dec 2007 16:36 GMT
Who created the concrete implementation for the MySql database?

http://www.google.com/search?source=ig&hl=en&rlz=&q=EnterpriseLibrary+MySql

You'll need to find those people and use their support.

The framework includes (if I recall correctly) Sql Server , Oracle and DB2.
(Aka, the included concrete versions)

But someone else has written the concrete version for MySql.

This is the error message and trace info:

This happens even I kill all connections:

Exception Details: MySql.Data.MySqlClient.MySqlException: error
connecting: Timeout expired.  The timeout period elapsed prior to
obtaining a connection from the pool.  This may have occurred because
all pooled connections were in use and max pool size was reached.

Stack Trace:

[MySqlException (0x80004005): error connecting: Timeout expired.  The
timeout period elapsed prior to obtaining a connection from the pool.
This may have occurred because all pooled connections were in use and
max pool size was reached.]
  MySql.Data.MySqlClient.MySqlPool.GetConnection() +124
  MySql.Data.MySqlClient.MySqlConnection.Open() +223

Microsoft.Practices.EnterpriseLibrary.Data.Database.OpenConnection()
in C:\WorkSpace\Microsoft Enterprise Library January 2006\src\Data
\Database.cs:1222

Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteScalar(DbCommand
command) in C:\WorkSpace\Microsoft Enterprise Library January 2006\src
\Data\Database.cs:588
  DataAccess.UserLogin(String pLoginId, String pPwd, String
pUserHost) +105
  Pages_Login.ButtonLogin_OnClick(Object sender, EventArgs e) +111
  System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs
e) +105
  System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String
eventArgument) +115

System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +7
  System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +11
  System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
+33
  System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
+5102

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42;
ASP.NET Version:2.0.50727.42

> Hi, all:
>
[quoted text clipped - 22 lines]
> Thanks in advance
> -rockdale
rockdale - 28 Dec 2007 17:22 GMT
Thanks, I think I figured it out. I ran my application on debug mode
and throw exceptions then I stoip the debugging, that's why the
connection is not closed ? I believe. Since after 2 days I do not have
this problem anymore.

The concrete implementation is downloaded from mysql website, they
called it .net connector.

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.