Re: Log4j Appender

nenad(dot)jaksic(at)imail(dot)de wrote:
> Hello,
>
> I'd like to use DBAppender or JDBCAppender to log to Postgres
> DB, I am not sure if any can send me some peace of code or clue or link
> how to do it. I also use Hibernete so I know
> there is also way to connect it to Hibernate to but preference
> is to make it with Log4j anyhow.
> Does somebody knows the correct way?

This works for me:

table:
----------------
create table log4j_messages
(
message varchar(2000),
class varchar(255),
priority varchar(64),
log_date timestamp
);

log4j.properties:
-----------------
### JDBC appender
# timestamp comes out like this: 2009-03-20 22:16:45,614
log4j.appender.jdbc=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.jdbc.driver=org.postgresql.Driver
log4j.appender.jdbc.URL=jdbc:postgresql://localhost:5432/postgres
log4j.appender.jdbc.user=xxxxx
log4j.appender.jdbc.password=yyyyy
log4j.appender.jdbc.sql=INSERT INTO log4j_messages (message, class,
priority, log_date) values ('%m', '%c', '%p', to_timestamp('%d',
'YYYY-MM-DD HH24:MI:SS,MS'))

--
Guy Rouillier