Right now autocommit does not work with blobs. Are you using autocommit?

david jencks

On 2001.12.21 13:02:46 -0500 jwcanada wrote:
> 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
>
>
>
>
> To unsubscribe from this group, send an email to:
> IB-Java-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>