Do you mean SqlHandler in JDBCAppender to log4j or just a Sqlhander? give me an example?
------ Ursprungligt meddelande ------------------- Från: Yu Xiang Xi (Maveo) <[EMAIL PROTECTED]> Datum: Tue, 13 Jan 2004 15:33:52 +0800 Ämne: RE: how to divide message column? Implement a SqlHandler instead of using sql in log4j.properties can help resolve this issue. -----Original Message----- From: Magnus Andersson [mailto:[EMAIL PROTECTED] Sent: 2004?1?13? 15:27 To: [EMAIL PROTECTED] Subject: how to divide message column? I got a problem. Irecived a message that looks like this: 2004-jan-07 14:16:03,125 INFO MyApp MyApp main - d9d73; 9df834jdf9; 9cvkdc9; 9didem89; And the problem is. That i want to put everything into a jdbc database and the message should be divided so, that after every ";" semicolon i want it to put into a new column i the database like these log4j.appender.ROOT.sql=insert into JDBCTEST (Date, Priority, Logger, Method, Message1 ,Message2,Message3,Message4) Is that possible. Or should i divide it in the java code? _______________________________________________________________ Vinn en helg på spa för 2 personer ? http://resor.spray.se --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] _______________________________________________________________ Vinn en helg på spa för 2 personer ? http://resor.spray.se
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
