Log4JJDBCAppender calling stored proc

[Mark Reyes]

Hello Guyz,

Good Day..

I need some functionality to log events in my apps and found the apache log4j logging api after googling for some time.

I am still reading and experimenting on the basic features but found out
about the JDBCAppender.

My question is that can I call stored procedures in Log4j instead of the usual SQL statement of "Insert into...." and if possible a good link also to learn how to do it.

I need to do some processing first before logging anything so I am thinking about using stored procedures. I am using SQL Server as my database backend.

Thanks for your future comments..

[Paul Clapham]

No, but you could certainly write a subclass of that appender which called the stored procedure when it initialized itself.

[Mark Reyes]

Hi Paul,

Thanks. I will start reading on it.