Re: Log4j Appender

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@burntmail.com>
>> An: pgsql-jdbc@postgresql.org
>> Betreff: Re: [JDBC] Log4j Appender
>
>> nenad.jaksic@imail.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@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-jdbc
>


--
Guy Rouillier