You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@logging.apache.org by "Ralph Goers (Jira)" <ji...@apache.org> on 2020/04/04 22:29:03 UTC

[jira] [Updated] (LOG4NET-629) Cannot insert Npgsql syntax

     [ https://issues.apache.org/jira/browse/LOG4NET-629?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ralph Goers updated LOG4NET-629:
--------------------------------

LOG4NET is now dormant.  

> Cannot insert Npgsql syntax
> ---------------------------
>
>                 Key: LOG4NET-629
>                 URL: https://issues.apache.org/jira/browse/LOG4NET-629
>             Project: Log4net
>          Issue Type: Bug
>          Components: Core
>    Affects Versions: 2.0.8
>            Reporter: Warit achavanuntakul
>            Priority: Major
>
> Well I saw this was reported before and got fixed once. But apparently it's back.
> I'm using AdoNetAppender with NPgsql. Whenever I insert an x parameter into commandText, it will say that x column doesn't exist. I have tried a variation of :x ?x @x and none seems to work. (:x will say the syntax is error)
> For example:
> <commandText value="INSERT INTO mylog(columnname) VALUES(@x)" />
> <parameter>
> <parameterName value="@x">
> will say that x doesn't exist.
>  
> <commandText value="INSERT INTO mylog(columnname) VALUES(:x)" />
> <parameter>
> <parameterName value="x">
> will say that syntax error near :



--
This message was sent by Atlassian Jira
(v8.3.4#803005)