Informix Error -9456: Cannot get large object length.

Reasons / Common Causes

-9456 fires when the database server can't obtain a large object's length over a JDBC connection — per the official guidance.

1. The JDBC connection the large object came from no longer being valid, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Make sure the connection from which the large object comes is still valid, per the official guidance.

Examples

N/A

No specific triggering statement is documented beyond an invalidated JDBC connection.

Diagnostic Checks

1. Check whether the originating JDBC connection is still open/valid, and reacquire the large object over a valid connection if not.

Related Errors / Related Topics

• -9455 — "Cannot access large object." A related large-object-access error, on a missing default sbspace rather than connection validity.
• -9457 — "Cannot convert large object handle to byte[]." A related large-object-access error, on content retrieval rather than length retrieval.
• -9458 — "Cannot start large object search." A related large-object-access error, on seek rather than length retrieval.
• -9459 — "Large object Error: (%s)." The general large-object-access error this is a specific case of, on length retrieval.

The large object's length couldn't be retrieved — check whether the originating JDBC connection is still valid.