Informix Error -79767: ResultSet Type is TYPE_FORWARD_ONLY.

Cause and resolution

ResultSet Type is TYPE_FORWARD_ONLY.

A method such as ResultSet.beforeFirst(), ResultSet.afterLast(), ResultSet.first(), ResultSet.last(), ResultSet.absolute(), ResultSet.relative(), ResultSet.current(), or ResultSet.previous() has been called, but the result set type is TYPE_FORWARD_ONLY.

Call only the ResultSet.next() method if the result set type is TYPE_FORWARD_ONLY.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-79767 fires when a positioning method other than next() is called on a TYPE_FORWARD_ONLY result set — per the official guidance.

beforeFirst(), afterLast(), first(), last(), absolute(), relative(), getRow(), or previous() called on a TYPE_FORWARD_ONLY result set, per the official guidance — the direct, only cause.

Solutions / Resolution

Call only ResultSet.next() on a TYPE_FORWARD_ONLY result set, per the official guidance.

Examples

N/A

No specific triggering statement is documented beyond an unsupported positioning-method call.

Diagnostic Checks

Check the result set's type, and confirm only next() is used if it's TYPE_FORWARD_ONLY.

Related Errors / Related Topics

-79768 — "Incorrect row value." A related result-set navigation error, on an invalid absolute(int) argument rather than an unsupported method for the result set type.

A positioning method other than next() was called on a TYPE_FORWARD_ONLY result set — use only next().