log4j within java stored procedure

I want be able write some information from db2 inserts into Windows Application Log. I try use log4j's NTEventLogAppender within java stored procedure, called from trigger.



example of SP:



package PKG71021015549570;



import java.sql.*;

import org.apache.log4j.Level;

import org.apache.log4j.Logger;

import org.apache.log4j.SimpleLayout;

import org.apache.log4j.nt.NTEventLogAppender;



public class PROCEDURE2

{

public static void pROCEDURE2 (int value ) throws SQLException, Exception

{

Logger logger = Logger.getLogger("computel.test");

logger.setLevel(Level.INFO);

NTEventLogAppender ntAppender = new NTEventLogAppender();

logger.addAppender(ntAppender);

Connection con = DriverManager.getConnection("jdbc:default:connection");

PreparedStatement stmt = null;

boolean bFlag;

String sql= "UPDATE VYAROSHEVICH.TEST2 SET \"COUNT\" = "+value;



stmt = con.prepareStatement( sql );

bFlag = stmt.execute();

logger.info("Test message 2: "+value);



}

}



It's works from db2 development Center, but calls from trigger or clp fail (sqlstate=38501)! What reason for it?



Is exist another way for event logging from DB2 on Windows?

dwforums-at-us.ibm.com wrote:

> I want be able write some information from db2 inserts into Windows
> Application Log. I try use log4j's NTEventLogAppender within java stored
> procedure, called from trigger.

example of SP:

>

> package PKG71021015549570;

>

> import java.sql.*;

> import org.apache.log4j.Level;

> import org.apache.log4j.Logger;

> import org.apache.log4j.SimpleLayout;

> import org.apache.log4j.nt.NTEventLogAppender;

>

> public class PROCEDURE2

> {

>

> public static void pROCEDURE2 (int value ) throws SQLException,
> Exception

> {

> Logger logger = Logger.getLogger("computel.test");

> logger.setLevel(Level.INFO);

> NTEventLogAppender ntAppender = new NTEventLogAppender();

> logger.addAppender(ntAppender);

>

> Connection con =
> DriverManager.getConnection("jdbc:default:connection");

> PreparedStatement stmt = null;
boolean bFlag;

> String sql= "UPDATE VYAROSHEVICH.TEST2 SET \"COUNT\" = "+value; > />
>

> stmt = con.prepareStatement( sql );

> bFlag = stmt.execute();

> logger.info("Test message 2: "+value);

>

> }

> }

>

> It's works from db2 development Center, but calls from trigger or clp
> fail (sqlstate=38501)! What reason for it?


> Is exist another way for event logging from DB2 on Windows?

What's the exact error message that you got?

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany