Informix Error -9448

-9448 Unequal number of parameters in SQL and Java signature (%s).

Make sure that the SQL and Java signatures that the CREATE FUNCTION or CREATE PROCEDURE statement has provided specify the same number of parameters.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9448 fires when a CREATE FUNCTION or CREATE PROCEDURE statement's SQL signature and its Java signature specify different numbers of parameters — per the official guidance.

A parameter-count mismatch between the SQL and Java signatures, per the official guidance — the direct, only cause.

Solutions / Resolution

Make sure the SQL and Java signatures specify the same number of parameters, per the official guidance.

Examples

A mismatched parameter count

CREATE FUNCTION my_func(a INT, b INT) RETURNING INT
   EXTERNAL NAME 'com.example.MyClass.myMethod(int)'
   LANGUAGE JAVA;
-- -9448: SQL signature has 2 parameters, Java signature has 1

Corrected

CREATE FUNCTION my_func(a INT, b INT) RETURNING INT
   EXTERNAL NAME 'com.example.MyClass.myMethod(int,int)'
   LANGUAGE JAVA;

Diagnostic Checks

Count the parameters in the SQL signature and the Java EXTERNAL NAME signature, and reconcile any mismatch.

Related Errors / Related Topics

-9449 — "Java UDR method not found or is not static: (%s)." A related Java-UDR registration error, on the method not existing/being non-static rather than a parameter- count mismatch.

The SQL and Java signatures specified a different number of parameters — reconcile the counts.