Thread: JAVA UDF issue!
01-12-07, 08:36 #1Registered User
- Join Date
- Dec 2006
Unanswered: JAVA UDF issue!
I am trying to execute two JAVA UDFs throough my DB2 SQL stored procedure .These two external routines are performing some critical function which is else not possible.When I try to execute, one of the UDF workes absolutely fine without errors separately but the other ones doestn run at all
and it produces the error as SQL 4306N SQLSTATE 42724...My UDF is unable to call the java method.I dont really understand the disparitry of why one is working fine whilie other is not even though they have been built on the same framework......can someone please explain the reason...
Thanks in Advance
01-12-07, 10:41 #2:-)
Provided Answers: 1
- Join Date
- Jun 2003
- Toronto, Canada
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."---
"It does not work" is not a valid problem statement.