Oninit
Talk to an expert →

Informix Error -9447

-9447 Cannot perform Java-to-SQL type mapping for type (%s).

The user-defined-type mapping is invalid. Refer to the J/Foundation documentation for allowed type mappings.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9447 fires when a user-defined-type mapping between Java and SQL is invalid — per the official guidance.

  1. An invalid user-defined-type mapping, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Refer to the J/Foundation documentation for allowed type mappings, per the official guidance, and correct the mapping.
Examples
N/A

No specific triggering statement is documented; the named type varies.

Diagnostic Checks
  1. Check the UDT's Java class against the J/Foundation documentation's list of allowed type mappings, and correct any mismatch.
Related Errors / Related Topics
  • -9443 — "Cannot find class for type (%s)." A related Java-type-mapping error, on the class being unfindable rather than the mapping being invalid.
  • -9496 — "Unable to map Java type to an SQL type or SQL type to a Java type." The general Java/SQL type-mapping error this is a specific case of.

A Java-to-SQL type mapping was invalid — check it against the J/Foundation documentation's allowed mappings.