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