Avinash created LOG4NET-384:
-------------------------------
Summary: Log4Net MySql connector
Key: LOG4NET-384
URL: https://issues.apache.org/jira/browse/LOG4NET-384
Project: Log4net
Issue Type: Bug
Affects Versions: 1.2.11
Environment: Windows 7 32bit
Reporter: Avinash
Priority: Critical
Hi,
Im having a issue using the mysql connector. Im trying to log to a mysql
database with custom fields. I had a similar confiugration using MS Sql server
with no issues, however with mysql i get the following error:
log4net:ERROR [AdoNetAppender] ErrorCode: GenericFailure. Exception while
writing to database
MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered
during command execution. ---> MySql.Data.MySqlClient.MySqlException
(0x80004005): Parameter '?ProjectId' must be defined.
at
MySql.Data.MySqlClient.Statement.SerializeParameter(MySqlParameterCollection
parameters, MySqlPacket packet, String parmName)
at MySql.Data.MySqlClient.Statement.InternalBindParameters(String sql,
MySqlParameterCollection parameters, MySqlPacket packet)
at MySql.Data.MySqlClient.Statement.BindParameters()
at MySql.Data.MySqlClient.Statement.Execute()
at MySql.Data.MySqlClient.PreparableStatement.Execute()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior
behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior
behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at log4net.Appender.AdoNetAppender.SendBuffer(IDbTransaction dbTran,
LoggingEvent[] events)
at log4net.Appender.AdoNetAppender.SendBuffer(LoggingEvent[] events)
Here is a snippet oog my config:
<appender name="ADONetAppender" type="log4net.Appender.AdoNetAppender">
<bufferSize value="1" />
<connectionType value="MySql.Data.MySqlClient.MySqlConnection, MySql.Data,
Version=6.0.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
<connectionString value="Data Source=localhost;database=test;
Uid=user;Pwd=password?" />
<commandText value="INSERT INTO Audit
(Date,Logger,ProjectId,Message,Exception) VALUES (?log_date, ?logger,
?ProjectId, ?message, ?exception)" />
<parameter>
<parameterName value="log_date" />
<dbType value="DateTime" />
<layout type="log4net.Layout.RawTimeStampLayout" />
</parameter>
<parameter>
<parameterName value="logger" />
<dbType value="String" />
<size value="255" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%logger" />
</layout>
</parameter>
<parameter>
<parameterName value="ProjectId " />
<dbType value="String" />
<size value="10" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%property{ProjectId}" />
</layout>
</parameter>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
