Calling Stored Procedure in Log4J
1 posts in topic
Flat View  Flat View

Posted By:   mark_reyes
Posted On:   Thursday, May 8, 2008 08:53 PM

Hello All,

I am trying to figure out on how to call a stored procedure in log4j.

From my initial reading i should extend jdbcappender but cant find enough resource on how to do this.

Has anyone done this or any useful link that I could read upon? I would surely appreciate your help. Thanks.

Re: Calling Stored Procedure in Log4J

Posted By:   Stephen_McConnell  
Posted On:   Friday, May 9, 2008 09:38 AM

Have you ever heard of someone doing this? I know you can persist log4j messages to a database, but I never thought you could call a "stored" procedure from log4j....

If you need something to happen when a log4j message is persisted to a database, you might think of a trigger. That way when a message is persisted, the trigger is fired and it does whatever you might need to happen. However, be advised, performance will suffer.

Stephen McConnell

About | Sitemap | Contact