-4000: Unknown result table and BLOB

[Former Member]

MAXDB 7.7.07.16. SQLDBC

Hello,

I have a table with a blob.

I create a recordset, and for each row, I update the row. The resultset fetchsize is 1

If the first update statement updates the blob, the next fetch on the recordset returns the error -4000: Unknown result table

if the update statement does not update de blob, the next fetch works.

if the cursor resultset type is FOWARD_ONLY it works with de BLOB

if the cursor resultset type is SCROLL_SENSITIVE or SCROLL_INSENSITIVE it does not work with de BLOB.

Of course I need SCROLL_INSENSITIVE cursor.

For information select and update are not executed on the same connection, and I commit transaction manually.

I use SQLDBC, in the documentation i find this parameter SQLDBC::SQLDBC_Statement::HoldabilityType

1) could holdability solve my issue ?

2) how can I use it ?

enum SQLDBC::SQLDBC_Statement::HoldabilityType

Enumerator:

CURSOR_HOLD_OVER_COMMIT The result persists after a COMMIT command.

CURSOR_CLOSE_ON_COMMIT The result is closed on COMMIT.

Definition at line 2297 of file SQLDBC.h.

Thanks for any help.

Yann

[Former Member]

Hello,

I fix my issue. I set a cursor name for my statement and the result table is not closed anymore.

Thanks.