[ 
http://jira.qos.ch/browse/LBCLASSIC-249?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12357#action_12357
 ] 

Marc Breitenreicher commented on LBCLASSIC-249:
-----------------------------------------------

Same problem with IBM DB2, is not just Oracle specifc.

> Logging Exceptions using DBAppender fails (at least on Oracle), when message 
> or stack frame is longer than 254 bytes
> --------------------------------------------------------------------------------------------------------------------
>
>                 Key: LBCLASSIC-249
>                 URL: http://jira.qos.ch/browse/LBCLASSIC-249
>             Project: logback-classic
>          Issue Type: Bug
>          Components: appender
>    Affects Versions: 0.9.28
>         Environment: Oracle DBMS
>            Reporter: Andreas Zielke
>            Assignee: Logback dev list
>            Priority: Minor
>
> Sometimes the DBAppender failed to log Exceptions, so I checked the status of 
> the StatusManager and found the folloging problem:
>  java.sql.BatchUpdateException: ORA-12899: Wert zu groß für Spalte 
> "SUBSYSTEMTEST"."LOGGING_EVENT_EXCEPTION"."TRACE_LINE" (aktuell: 692, 
> maximal: 254)
> Possible fix:
> After reading the code of DBAppender I subclassed it and changed the code of 
> the method
> void updateExceptionStatement(PreparedStatement exceptionStatement, String 
> txt, short i, long eventId)
> so that the text would be shortened accordingly. 
> This seems to be the most consistent workaround, as many other columns are 
> also only 254 bytes wide.
> I'd much rather have a wider column and not loose information, though. (This 
> would be consistent with the changes to LOGGING_EVENT_EXCEPTION as proposed 
> in LBCLASSIC-170).

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://jira.qos.ch/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

       
_______________________________________________
logback-dev mailing list
[email protected]
http://mailman.qos.ch/mailman/listinfo/logback-dev

Reply via email to