Topic: Calling Stored Procedure in Log4J

Calling Stored Procedure in Log4J

1 posts in topic

Flat View

Thread View

Older Post First | Reply to Topic

TOPIC ACTIONS:

Print Topic

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.

Report | Quote This | Send private message | Reply | Print

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

Report | Quote This | Send private message | Reply | Print