I have created a java stored procedure in DB2 using the development center. Building it produces the following pl/sql:
CREATE PROCEDURE DB2ADMIN.READZIPCODE ( IN addressData CHARACTER(32),
OUT zipcode CHARACTER(32) )
EXTERNAL NAME 'DB2ADMIN.SQL40801041244480:READZIPCODE.rEADZIPCOD E'
PARAMETER STYLE JAVA
SQL4306N Java stored procedure or user-defined function
"DB2ADMIN.READZIPCODE", specific name "SQL040901161316545"
could not call Java method "rEADZIPCODE", signature
The Java method given by the EXTERNAL NAME clause of a CREATE
PROCEDURE or CREATE FUNCTION statement could not be found. Its
declared argument list may not match what the database expects,
or it may not be a "public" instance method.
Ensure that a Java instance method exists with the "public" flag
and the expected argument list for this call.
sqlcode : -4306
sqlstate : 42724
The java method exists and is public and the expected arguments are called. The jar is under the
SQLLIB\FUNCTION\jar\DB2ADMIN directory which exists in the classpath. Any ideas what to try from here.