In this blog post, let’s learn about the error message “11207 Java method method-name was not found in Java class class-file-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11207 Java method method-name was not found in Java class class-file-name.
Reason for the Error
The Java method given in the CREATE PROCEDURE statement was not found in the class file or, if this is a CALL statement, the Java method corresponding to the stored procedure was not found in the class file.
Solution
Verify that the Java method exists in the class file and that it has the public and static attributes, and then retry the SQL/MX statement. Use the NonStop Server for Java javap utility to determine which methods exist in a given class file. If this is a CALL statement, determine if the class file was removed or modified after the stored procedure was created. If so, you might need to drop and recreate the stored procedure
