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??