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
