The best advice I can give you is generally, close the connections ASAP, that
way they aren't outstanding, taking up resources and are available to use.
Connection pools are in theory a great idea and I use them for most of my java
work, especially on weblogic because it implements them so well. I have also
written my own connection pools before. I have not used them in .net yet
because I write system code that only has one user at a time so I simply
connect-disconnect one connection. In general you want to return any resource
as soon as you can. Are you writing in C# if so look into the using statement.
For example:
using (SqlConnection conn = new
SqlConnection(myApplicationData.ConnectionString)) {
conn.Open();
using (SqlCommand command = new
SqlCommand("getFileWatcherDomainObjects", conn)) {
using (SqlDataReader dataReader = command.ExecuteReader()) {
while (dataReader.Read()) {
}
}
}
}
Travis D. Falls | Consultant RAFT.Net IT | 860.547.4070 | [EMAIL PROTECTED]
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 25, 2005 10:46 AM
To: [email protected]
Subject: RE: [AspNetAnyQuestionIsOk] Timeout expired
DAL (Data Access Layer). OK, makes sense to me. I didn't know what it was -
Database Abstraction Layer is something I remember about when I was reading php
stuff, I don't use it either.
So, what I need to do is free up some connections to the pool. Is using pooled
connections a bad idea? Or am I just leaving too many open... What DAL code
will I need to learn this?
Thank-you
"Falls, Travis D (HTSC, CASD)" <[EMAIL PROTECTED]> wrote:
Sorry DAL is an acronym we use (at least at The Hartford) for Data Access
Layer. Basically it seems when you access your database you are doing it via a
pool and there aren't any free connections in the pool to use. Now I noticed
you mentioned PHP; I am assuming you are coding in .net on this list... I am no
PHP guy that is for sure... java, .Net, Action Script, and groovy sure... PHP
nope. ;-)
Travis D. Falls | Consultant RAFT.Net IT | 860.547.4070 | [EMAIL PROTECTED]
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 25, 2005 9:52 AM
To: [email protected]
Subject: RE: [AspNetAnyQuestionIsOk] Timeout expired
I'd be glad to. Do you know where I can find this DAL code? I do not recall
any php in my coding so this must be generated some other way. Let me know and
will post it so you can see what me be happening. Thank-you.
"Falls, Travis D (HTSC, CASD)" <[EMAIL PROTECTED]> wrote:It looks like you are
trying to grab a connection out of a connection pool and they are all being
used and that the attempt to get a connection is timing out. Post some of your
DAL code and we can try to see what's going on.
Travis D. Falls | Consultant RAFT.Net IT | 860.547.4070 | [EMAIL PROTECTED]
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 25, 2005 9:22 AM
To: [email protected]
Subject: [AspNetAnyQuestionIsOk] Timeout expired
Can someone please tell me how to debug this error?:
System.InvalidOperationException: 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. at
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection
(SqlConnectionString options, Boolean& isInTransaction) at
System.Data.SqlClient.SqlConnection.Open() at...
Thank-you
Yahoo! Groups Links
*************************************************************************
This communication, including attachments, is
for the exclusive use of addressee and may contain proprietary,
confidential and/or privileged information. If you are not the intended
recipient, any use, copying, disclosure, dissemination or distribution is
strictly prohibited. If you are not the intended recipient, please notify
the sender immediately by return e-mail, delete this communication and
destroy all copies.
*************************************************************************
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "AspNetAnyQuestionIsOk" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
Yahoo! FareChase - Search multiple travel sites in one click.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
SPONSORED LINKS
Basic programming language Computer programming languages Programming languages
Java programming language
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "AspNetAnyQuestionIsOk" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
Yahoo! FareChase - Search multiple travel sites in one click.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
