[jira] [Commented] (LOG4NET-384) Log4Net MySql connector

["Avinash (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/LOG4NET-384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13709655#comment-13709655 ] 

Avinash commented on LOG4NET-384:
---------------------------------

I have also seen some blogs on this, but non report this issue.
http://blogs.lessthandot.com/index.php/WebDev/ServerProgramming/using-postsharp-and-log4net-to-set-up-co

http://rafayal.blogspot.com/2009/05/using-log4net-with-c-and-mysql.html

                
> 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