You are viewing a plain text version of this content. The canonical link for it is here.
Posted to log4net-dev@logging.apache.org by ni...@apache.org on 2006/10/28 23:39:48 UTC
svn commit: r468745 -
/logging/log4net/trunk/examples/net/1.0/Appenders/SampleAppendersApp/cs/src/Appender/FastDbAppender.cs
Author: nicko
Date: Sat Oct 28 14:39:47 2006
New Revision: 468745
URL: http://svn.apache.org/viewvc?view=rev&rev=468745
Log:
Added check to FastDbAppender to only open the database connection if it is closed.
Modified:
logging/log4net/trunk/examples/net/1.0/Appenders/SampleAppendersApp/cs/src/Appender/FastDbAppender.cs
Modified: logging/log4net/trunk/examples/net/1.0/Appenders/SampleAppendersApp/cs/src/Appender/FastDbAppender.cs
URL: http://svn.apache.org/viewvc/logging/log4net/trunk/examples/net/1.0/Appenders/SampleAppendersApp/cs/src/Appender/FastDbAppender.cs?view=diff&rev=468745&r1=468744&r2=468745
==============================================================================
--- logging/log4net/trunk/examples/net/1.0/Appenders/SampleAppendersApp/cs/src/Appender/FastDbAppender.cs (original)
+++ logging/log4net/trunk/examples/net/1.0/Appenders/SampleAppendersApp/cs/src/Appender/FastDbAppender.cs Sat Oct 28 14:39:47 2006
@@ -75,9 +75,12 @@
{
using(IDbConnection connection = GetConnection())
{
- // Open the connection for each event, this takes advantage
- // of the builtin connection pooling
- connection.Open();
+ if (connection.State == ConnectionState.Closed)
+ {
+ // Open the connection for each event, this takes advantage
+ // of the builtin connection pooling
+ connection.Open();
+ }
using(IDbCommand command = connection.CreateCommand())
{
@@ -141,7 +144,7 @@
command.CommandType = CommandType.Text;
command.CommandText = "INSERT INTO [LogTable] ([Time],[Logger],[Level],[Thread],[Message]) VALUES (@Time,@Logger,@Level,@Thread,@Message)";
- IDbDataParameter param = null;
+ IDbDataParameter param;
// @Time
param = command.CreateParameter();