[
https://issues.apache.org/jira/browse/ARROW-118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17657216#comment-17657216
]
Rok Mihevc commented on ARROW-118:
----------------------------------
This issue has been migrated to [issue
#15532|https://github.com/apache/arrow/issues/15532] on GitHub. Please see the
[migration documentation|https://github.com/apache/arrow/issues/14542] for
further details.
> 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
> Priority: Major
>
> 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
(v8.20.10#820010)
