Thanks. That should solve that stack trace size problem. I assume then even though the comment in the code says varchar(256) I could increase that up to varchar(4000) if I desire.
I would like to store a large value (actually the contents of a file) in an MDC value. How would you suggest that I handle that? I actually wouldn't care if the value was truncated at some reasonable limit. James Stauffer -----Original Message----- From: Ceki Gülcü [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 2:51 AM To: Log4J Users List Subject: RE: Logging to Database: max column size 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:[EMAIL PROTECTED] >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: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
