Subject | FBResultSet Blob field Retrieve |
---|---|
Author | jwcanada |
Post date | 2001-12-21T18:02:46Z |
I have a table which have a Memo field defined as
"MEMO BLOB sub_type 1 segment size 80"
When I tried to access it
rs.getString("MEMO")
I got Exception, saying
couldn't open blob: 3650722201600 exception: invalid transaction
handle (expecting explicit transaction start)
When I debug, it give
int sqltype = getXsqlvar(columnIndex).sqltype & ~1;
Found the sqltype is 520 instead of GDS.SQL_TEXT which is 452.
Anyone know what caused the problems.
jw
"MEMO BLOB sub_type 1 segment size 80"
When I tried to access it
rs.getString("MEMO")
I got Exception, saying
couldn't open blob: 3650722201600 exception: invalid transaction
handle (expecting explicit transaction start)
When I debug, it give
int sqltype = getXsqlvar(columnIndex).sqltype & ~1;
Found the sqltype is 520 instead of GDS.SQL_TEXT which is 452.
Anyone know what caused the problems.
jw