2006 Java技术的赢家和输家

csdn blog功能最近更新的比较多，自然相应的也暴露出一些问题。在一次访问的时候，我得到了下面的抱错信息。感觉有几个地方应该做一些小小的处理，贴在这里，瑞江不要骂我啊

1 应该捕获connection timeout异常
2 所有系统异常应该跳转到特定的页面，以便隐藏系统信息
  上面直接暴露了源程序的位置，操作系统, .net版本信息
3 不知道是否由于sql server是正版，连接数量有限制，我觉得应该自己实现连接池，最好不要有上限，但是有一个自动回收机制，当多余的连接空闲的时候，自动将超过上限的连接关闭。
4 很多时候连接池是不会饱和的，出现这种现象可能是由于某些访问产生了死锁，需要对sqlserver进行进一步的排查

Server Error in '/' Application.
--------------------------------------------------------------------------------

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.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the

error and where it originated in the code.

Exception Details: 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.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be

identified using the exception stack trace below. 

Stack Trace:

[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.]
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +1184505
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
   System.Data.SqlClient.SqlConnection.Open() +111
   Dottext.Framework.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) in

D:/CSDN Web Site/Csdn Blog/Src/Library/Data Providers/Dottext.SqlDataProvider/SQLHelper.cs:871
   Dottext.Framework.Data.SqlDataProvider.GetPreferences(Int32 blogId) in D:/CSDN Web Site/Csdn Blog/Src/Library/Data

Providers/Dottext.SqlDataProvider/SqlDataProvider.cs:3939
   Dottext.Framework.Components.Preferences.Get(Int32 blogId) +91
   Dottext.Admin.Pages.AdminPage.get_Preferences() in D:/CSDN Web Site/Csdn Blog/Src/Library/Dottext.Admin/WebUI/AdminPage.cs:167
   Dottext.Admin.Pages.Feedback.Page_Load(Object sender, EventArgs e) in D:/CSDN Web Site/Csdn Blog/Src/Web/writeblog_app.csdn.net/Feedback.aspx.cs:31
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   Dottext.Admin.Pages.AdminPage.OnLoad(EventArgs e) in D:/CSDN Web Site/Csdn Blog/Src/Library/Dottext.Admin/WebUI/AdminPage.cs:74
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

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

Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=1656030