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.
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