Hi,
I am using DB2 V9.5 on windows XP platform. I am newbie to db2. I am able to deploy java stored procedure(JSP) successfully. My JSP call other classes also, which I have packed in the same jar file. I installed that jar using sqlj.install_jar. But while calling JSP I get the following error
HTML Code:
------------------------------ Commands Entered ------------------------------
call FINALPROC1('GOKOTHAR','gokothar','xxxxxx','govind','select NAME,REGION,SOURCE from finaltable where year(closed_date)=2006');
------------------------------------------------------------------------------
call FINALPROC1('GOKOTHAR','gokothar','xxxxxx','govind','select NAME,REGION,SOURCE from finaltable where year(closed_date)=2006')
SQL4302N Procedure or user-defined function "GOKOTHAR.FINALPROC1", specific
name "SQL080813112812100" aborted with an exception "[IBM][CLI Driver]
SQL0751N Rou".
SQL4302N Procedure or user-defined function "GOKOTHAR.FINALPROC1", specific name "SQL080813112812100" aborted with an exception "[IBM][CLI Driver] SQL0751N Rou".
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
----------------------------------------------------------------------
I also don't know how to use debugger. Does anyone has solution to my problem??
dBforums
>
problem deploying java stored procedure with dependent classe
08-13-08, 05:30
Linear Mode
