Oninit
Talk to an expert →

Informix Error -9496

-9496 Unable to map Java type to an SQL type or SQL type to a

Java type.

Unable to map between the Java type and the specified SQL type. This error is usually raised when the database server is unable to start a Java user-defined routine because its SQL types could not be mapped to Java types.

Check the declaration of the Java user-defined routine.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9496 fires when the database server can't map between a Java type and a SQL type — per the official guidance.

  1. A Java UDR's SQL types that couldn't be mapped to Java types, per the official guidance — the most common named cause, preventing the database server from starting the routine.
Solutions / Resolution
  1. Check the declaration of the Java user-defined routine, per the official guidance, for the mismatched type.
Examples
N/A

No specific triggering statement is documented beyond a Java/SQL type-mapping failure at UDR startup.

Diagnostic Checks
  1. Check the Java UDR's CREATE FUNCTION/PROCEDURE declaration for its parameter and return types, against the J/Foundation documentation's allowed type mappings.
Related Errors / Related Topics
  • -9447 — "Cannot perform Java-to-SQL type mapping for type (%s)." The specific, named-type case of this general Java/SQL type-mapping error.

A Java type couldn't be mapped to/from a SQL type — check the UDR's declared parameter and return types.