logging-log4j-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ceki Gülcü <c...@qos.ch>
Subject RE: Logging to Database: max column size
Date Tue, 11 May 2004 07:50:39 GMT
At 12:18 AM 5/11/2004, James Stauffer wrote:
>Thanks.  I updated and see the change.  It appears you write each line to a
>distinct record so that you can support very long stack traces.  Is that
>correct?

That is correct, each stack trace line gets its own row in the
table. This allows us to support very long stack traces but more
importantly it makes the output be language independent. Our aim is to
have DBAppender output to be independent of the Java language.

>-----Original Message-----
>From: Ceki Gülcü [mailto:ceki@qos.ch]
>Sent: Monday, May 10, 2004 12:12 PM
>To: Log4J Users List
>Subject: Re: Logging to Database: max column size
>
>
>DBAppender which is not even checked in yet, logs exceptions to its own
>table worth each trace line having its own row. I am working on it right
>now. It should be available very soon.
>
>At 06:54 PM 5/10/2004, James Stauffer wrote:
> >Do any of the database appenders log a LogEvent even if one of the pieces
>of
> >data is too big to fit in that field?  i.e. In Oracle a varchar2 can be up
> >to 4000 characters (without using a different way to write the data), but
>if
> >a insert a logging event with a message more than 4000 characters the
>insert
> >fails.  From what I remember MS SQL just truncates the data (which would be
> >fine with me).  I know that 4000 characters seems like a lot but our stack
> >trace messages can be very verbose (have all of the data from a document).
> >Is this issue handled by any database loggers?
> >
> >James Stauffer
>
>--
>Ceki Gülcü
>
>       For log4j documentation consider "The complete log4j manual"
>       ISBN: 2970036908 http://www.qos.ch/shop/products/clm_t.jsp
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: log4j-user-unsubscribe@logging.apache.org
>For additional commands, e-mail: log4j-user-help@logging.apache.org

-- 
Ceki Gülcü

      For log4j documentation consider "The complete log4j manual"
      ISBN: 2970036908 http://www.qos.ch/shop/products/clm_t.jsp  



---------------------------------------------------------------------
To unsubscribe, e-mail: log4j-user-unsubscribe@logging.apache.org
For additional commands, e-mail: log4j-user-help@logging.apache.org


Mime
View raw message