From: | Guy Rouillier <guyr-ml1(at)burntmail(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Log4j Appender |
Date: | 2009-03-23 16:51:07 |
Message-ID: | 49C7BDFB.40703@burntmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Nenad Jaksic wrote:
> Hello,
Please reply to the list and not to me individually.
> thanks, is it necessary also to adjust log level?
Not necessary. JDBCAppender is just an appender, like any other. It
will log whatever levels you tell it to.
> Also I' red that JDBCAppender does not log exceptions.
I see the same comment in the Javadoc. You can easily get around this
by just converting your exception to text.
>
> -------- Original-Nachricht --------
>> Datum: Fri, 20 Mar 2009 23:37:26 -0400
>> Von: Guy Rouillier <guyr-ml1(at)burntmail(dot)com>
>> An: pgsql-jdbc(at)postgresql(dot)org
>> Betreff: Re: [JDBC] 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
>>
>> --
>> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-jdbc
>
--
Guy Rouillier
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2009-03-23 17:54:29 | Re: Test suite failures? |
Previous Message | Maciek Sakrejda | 2009-03-23 16:12:08 | Test suite failures? |