Informix Error -9449

Reasons / Common Causes

-9449 fires when the Java method named in a CREATE FUNCTION/CREATE PROCEDURE statement doesn't exist as a public static method, or its signature doesn't match — per the official guidance.

1. The named method missing, or not declared public static, per the official guidance — the first named cause.
2. A signature mismatch between the defined method and the CREATE FUNCTION/CREATE PROCEDURE statement, per the official guidance — the second named cause.

Solutions / Resolution

1. Make sure the specified Java method exists as a public static method in the specified class, per the official guidance.
2. Make sure the method's signature matches what CREATE FUNCTION/CREATE PROCEDURE specified, per the official guidance.

Examples

A non-static Java UDR method

public class MyClass {
    public int myMethod(int a) { ... }   // -9449: not static
}

Corrected

public class MyClass {
    public static int myMethod(int a) { ... }
}

Diagnostic Checks

1. Check the Java class for the named method's modifiers (public static) and signature, and correct it or the CREATE FUNCTION/PROCEDURE statement to match.

Related Errors / Related Topics

• -9442 — "Error loading Java UDR class (%s)." A related Java-UDR registration error, on the class not loading at all rather than the method within it.
• -9448 — "Unequal number of parameters in SQL and Java signature (%s)." A related Java-UDR registration error, on parameter count specifically rather than method existence/modifiers.

The named Java UDR method wasn't found, wasn't static, or its signature didn't match — check the method's modifiers and signature against the CREATE FUNCTION/PROCEDURE statement.