[
https://issues.apache.org/jira/browse/ARROW-118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Wes McKinney closed ARROW-118.
------------------------------
Resolution: Invalid
Assignee: Wes McKinney
This is the JIRA for Apache Arrow, please open this issue on the LOG4NET project
> Cant insert log date using stored procedure using log4net
> ---------------------------------------------------------
>
> Key: ARROW-118
> URL: https://issues.apache.org/jira/browse/ARROW-118
> Project: Apache Arrow
> Issue Type: Bug
> Reporter: vivek
> Assignee: Wes McKinney
>
> I am trying do logging using stored procedure. I created a stored procedure
> which will insert a row in to the table
> CREATE PROCEDURE [dbo].[usp_insert_log]
> (
> @log_date datetime,
> @log_level varchar(10),
> @log_message nvarchar(max)
> )
> AS
> BEGIN
> INSERT INTO [dbo].[Log] ([log_date], [log_level], [log_message])
> VALUES (@log_date, @log_level, @log_message)
> END
> In my config file
> <appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">
> <bufferSize value="1" />
> <connectionType value="System.Data.SqlClient.SqlConnection, System.Data,
> Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
> <connectionStringName value="AnalyticsLogging" />
> <commandText value="usp_insert_log" />
> <parameter>
> <parameterName value="@log_date" />
> <dbType value="DateTime" />
> <layout type="log4net.Layout.RawTimeStampLayout">
> <conversionPattern value="%date" />
> </layout>
> </parameter>
> </appender>
> I am getting the following error
> log4net:ERROR [AdoNetAppender] ErrorCode: GenericFailure. Exception while
> writing to database
> System.Data.SqlClient.SqlException (0x80131904): Procedure or function
> 'usp_insert_log' expects parameter '@log_date', which was not supplied.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
