db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Suresh Thalamati <suresh.thalam...@gmail.com>
Subject Re: unable to execute procedure
Date Tue, 04 Apr 2006 23:47:06 GMT
Anil Samuel wrote:
> I also did
>
> 
>     2. Compiled and created dtpLeaveApp.jar with this class.
>     3 . Added this jar to derby by
>     CALL SQLJ.install_jar(
>         'file:/tmp/dtpLeaveApp.jar',
>         'dtp.LeaveApp_jar',
>         0
>     );
>     4. Tried to execuet this procedure by doing
>     CALL dtp.TOTAL_LEAVE_FOR_TYPE('TOM',3);
>     but it results
>     ERROR 42Y03: 'SQLJ.INSTALL_JAR' is not recognized as a function or
>     procedure.

  I wonder how one can get "ERROR 42Y03: 'SQLJ.INSTALL_JAR"....error
  when you execute  CALL dtp.TOTAL_LEAVE_FOR_TYPE('TOM',3);

May be that error message is related to unsuccessful attempts to 
execute CALL SQLJ.install_jar() ...


> 
>     How do I get this working ?

To execute "CALL dtp.TOTAL_LEAVE_FOR_TYPE('TOM',3);" successfuly 
dtp.LeaveApp_jar  has to be in the database classpath.

One way to do that is :
callSYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.database.classpath', 
'dtp.LeaveApp_jar');


hope that helps
-suresh

Mime
View raw message