[jira] [Updated] (LOG4NET-461) The AdoNetAppender

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

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

Dominik Psenner updated LOG4NET-461:
------------------------------------
    Summary: The AdoNetAppender   (was: adonetappender )

> The AdoNetAppender 
> -------------------
>
>                 Key: LOG4NET-461
>                 URL: https://issues.apache.org/jira/browse/LOG4NET-461
>             Project: Log4net
>          Issue Type: Bug
>          Components: Appenders
>    Affects Versions: 1.2.11
>            Reporter: Kelly Elton
>            Assignee: Dominik Psenner
>            Priority: Critical
>             Fix For: 2.0.9
>
>
> Basically what happens is you guys store the SqlCommand between all requests. The problem is, sometimes this prepared statement gets removed from the cache in SqlServer. When this happens all subsequent requests result in an error "Could not find prepared statement with handle -1"
> You could resolve this by checking for that specific error on submitting and if you get it recreate the command and try again, or just recreate and prepare the statement every time.
> This is a pretty major issue.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)