Log4J JDBCAppender

[Subhasish Mohanty]

I have a log4j.properties where i am using JDBCAppender to log to the database:

log4j.appender.jdbc.sql=insert into invocation_count (invocation_time, facade_id) values ('%d{yyyy-MM-dd HH:mm:ss}','%m')

when i do log.debug("msg");

the datetime and message value are inserted to the database table.

is there any way to to have the sql as :

insert into cpm_invocation_count (invocation_time, facade_id, first_name, last_name) values ('%d{yyyy-MM-dd HH:mm:ss}','%m', '%m', '%m')

so that i can log multiple messages into database multiple columns.

Thanks & Regards,
Subhasish Mohanty

[lovelesh]

insert into cpm_invocation_count (invocation_time, facade_id, first_name, last_name) values ('%d{yyyy-MM-dd HH:mm:ss}','%m', '%m', '%m')

so that i can log multiple messages into database multiple columns.

You can log the same message (i.e the single message which we usually pass to logger) any number of times in many columns. But, if you want multiple different messages in same row (in different columns), then log4j is not the solution.:(

You can gather more info on this by looking at the source of log4j's Logger class.

[Subhasish Mohanty]

Thanks a lot

[kemot]

you can execute procedure "call my_procedure('%m')" instead of "insert" then you can extract inside my_procedure from message data and insert them to many columns. But you need pay attention about performance.