Hi All,

I am calling a java method from a DB2 storedproc and I am using MQ API with in that java method it is giving exception as follows:

------------------------------ Commands Entered ------------------------------
CALL SELECT_PROC3(1);
------------------------------------------------------------------------------
CALL SELECT_PROC3(1)
SQL4302N Procedure or user-defined function "DB2ADMIN.SELECT_PROC3", specific
name "SELECT3" aborted with an exception "com/ibm/mq/MQEnvironment".
SQLSTATE=38501

SQL4302N Procedure or user-defined function "DB2ADMIN.SELECT_PROC3", specific name "SELECT3"
aborted with an exception "com/ibm/mq/MQEnvironment ".

Explanation:

The procedure or user-defined function aborted with an exception.
The administration notification log contains a stack traceback
for the aborted routine.

User Response:

Debug the routine to eliminate the exception.

sqlcode : -4302

sqlstate : 38501


Can some one help me to resolve the issue.

Thanks in advance.

or build the sp with debug option and call a java debugger
or add code to intercept the exception and print some relevant data when the error occures