LOG4J Help URGENT!!!!!!!

[Ashok George]

if my understanding is not wrong while using LOG4J JDBCappender to write to a DataBase using configurator file(Property file), the SQL will be written in the property file and the message to be logged into the DB will be passed from the program(java file ) to the log4J system using the log.debug or any other way.
for eg: INSERT INTO JDBCTEST (Date, Logger, Priority, Message) VALUES ('%d', '%c', '%p', '%m')
here the only message passed t th eLOG4J system is the Message field value which is

represnted by the %m field(inside the value block) and rest are kind of constants , like for date (where we can use sysdate) and the logger and priority level which all are constants and not part of the message passed to the system(LOG4J system).
the trouble we found was in separating the single message we send to the LOG4J system

for eg: suppose if the message we send to the LOG4J system is
" methodname=ABC() timetaken=1.5secs date=28/7/2006 "
i am confused about the way to split the message into say 3 parts
like

methodname=ABC()
methodname=ABC()
date=28/7/2006

and insert into different columns of the table

Hope you got a good broader view of the problem i am facing.

[Ben Souther]

Ashok George,
Welcome to JavaRanch!

In an effort to help you get the most from our forums, we've compiled a
list of tips for asking questions here. You can find the list in our
FAQ section here.
In particular, please see EaseUp to find out how adding "URGENT" to your post or subject line will keep you from getting good answers in a timely manner.



Again, welcome to JavaRanch and good luck with your question.
-Ben

[David O'Meara]

Check out (I believe it is either) NDC or MDC. You can define your own LOog4J values and then pick em back out using %U{myval1}

Or something like that. I'd go look for full details but I opted for a faster rather than more concide post

[Jaikiran Pai]

As David mentioned, you can achieve this through MDC. Have a look at the NDC/MDC section at:

Log4j article

Log4j MDC article

You will find a code sample(MDCUserServletFilter.java) at:
Code sample - this is just a sample, you need not use a servlet.

Then use the [%X{yourVal}] as part of the ConversionPattern of the appender in the log4j.xml
[ July 31, 2006: Message edited by: jaikiran pai ]