Informix Error -9458: Cannot start large object search.
Cause and resolution
Cannot start large object search.
The database server cannot perform seek on a large object using a JDBC connection. Make sure the connection from which the large object comes is still valid.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-9458 fires when the database server can't perform a seek on a large object over a JDBC connection — per the official guidance.
- The JDBC connection the large object came from no longer being valid, per the official guidance — the direct, only cause.
Solutions / Resolution
- 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
- 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.
- -9456 — "Cannot get large object length." A related large-object-access error, on length retrieval rather than seek.
- -9457 — "Cannot convert large object handle to byte[]." A related large-object-access error, on content retrieval rather than seek.
- -9459 — "Large object Error: (%s)." The general large-object-access error this is a specific case of, on seek.
A seek on a large object couldn't be started — check whether the originating JDBC connection is still valid.