Java Stored Procedures

[Tim Troup]

Hi,

I have created some stored procedures in Java, compiled the classes,  
packaged them in a jar file and added the jar file to my classpath.


When I try and create a trigger which invokes the stored procedure I  
get a ClassNotFound error:

ij> CREATE PROCEDURE CALC_SCORE(
    IN COPUBID INTEGER
)
LANGUAGE JAVA PARAMETER STYLE JAVA
NO SQL
EXTERNAL NAME 'uk.ac.ed.med.textmining.procedures.CalcScore.calcScore';



ij> CREATE TRIGGER SCORETRIG
    AFTER INSERT ON COPUB
    REFERENCING NEW AS COPUB
    FOR EACH ROW MODE DB2SQL
    CALL CALC_SCORE(COPUB.ID);
ERROR 42X51: The class 'uk.ac.ed.med.textmining.procedures.CalcScore'  
does not exist or is inaccessible. This can happen if the class is  
not public. SQLSTATE: XJ001: Java exception:  
'uk.ac.ed.med.textmining.procedures.CalcScore:  
java.lang.ClassNotFoundException'.


How do I make the Java stored procedures available to Derby?

Thanks,

Tim