Does anyone know how to configure apache commons logging for Java Stored procedures?
I am trying to create a Java stored procedure that calls a web service via the Apache Axis framework. When I call the storedprocedure, it fails because (I think) it cannot write to log using the commons logging. I suspect this is a configuration issue, but I don't know what to do. The web service works fine when it is callled outside of DB2. The error only occurs when the web service is called from a DB2 stored procedure. The following is written in the db2diag.log file:
2006-11-02-16.49.43.781000-420 E422627H375 LEVEL: Warning
PID : 3668 TID : 2240 PROC : db2fmp.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, BSU Java support, sqlejLogException, probe:10
MESSAGE : ADM10000W A Java exception has been caught. The Java stack
traceback has been written to the db2diag.log.
2006-11-02-16.49.43.781000-420 I423004H2232 LEVEL: Warning
PID : 3668 TID : 2240 PROC : db2fmp.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, BSU Java support, sqlejLogException, probe:10
DATA #1 : String, 1868 bytes
java.lang.ExceptionInInitializerError
at java.lang.J9VMInternals.initialize(J9VMInternals.j ava:167)
at org.apache.axis.description.TypeDesc.<clinit>(Type Desc.java:61)
at java.lang.J9VMInternals.initializeImpl(Native Method)
at java.lang.J9VMInternals.initialize(J9VMInternals.j ava:161)
at com.webmethods.www._package.com_esri_is_services_s oap_v3_common.Address.<clinit>(Address.java:250)
at java.lang.J9VMInternals.initializeImpl(Native Method)
at java.lang.J9VMInternals.initialize(J9VMInternals.j ava:161)
at com.idfbins.gis.GISServices.getAddressCandidates(G ISServices.java:272)
at com.idfbins.gis.GISServices.validateAddress(GISSer vices.java:215)
at com.idfbins.storedproc.GISStoredProcs.validateAddr ess(GISStoredProcs.java:52)
Caused by: org.apache.commons.discovery.DiscoveryException: No implementation defined for org.apache.commons.logging.LogFactory
at org.apache.commons.discovery.tools.ClassUtils.veri fyAncestory(ClassUtils.java:176)
at org.apache.commons.discovery.tools.SPInterface.ver ifyAncestory(SPInterface.java:201)
at org.apache.commons.discovery.tools.SPInterface.new Instance(SPInterface.java:195)
at org.apache.commons.discovery.tools.DiscoverClass.n ewInstance(DiscoverClass.java:579)
at org.apache.commons.discovery.tools.DiscoverSinglet on.find(DiscoverSingleton.java:418)
at org.apache.commons.discovery.tools.DiscoverSinglet on.find(DiscoverSingleton.java:378)
at org.apache.axis.components.logger.LogFactory$1****n (LogFactory.java:45)
at java.security.AccessController.doPrivileged(Access Controller.java:191)
at org.apache.axis.components.logger.LogFactory.getLo gFactory(LogFactory.java:41)
at org.apache.axis.components.logger.LogFactory.<clin it>(LogFactory.java:33)
at java.lang.J9VMInternals.initializeImpl(Native Method)
at java.lang.J9VMInternals.initialize(J9VMInternals.j ava:161)
... 9 more