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();
