Subject Re: [Firebird-Java] Mac OSX and Varchar
Author Roman Rokytskyy
> I am porting an application from Windows to Mac OSX. I ran into a
> few database converstion issues I have gotton around, but my newest
> issue is the following:
>
> org.firebirdsql.FBSQLException: Resource Exception. Unrecognized
> transaction.

Can you post complete stack trace?

> Same query works on Windows FB (both 1.5).

Can you try to reproduce it with the different types of drivers (pure java,
native)? Does it work, if you try to execute same statements in isql?

> If I select * from CLOZE_LESSON, I will get the error. If I only
> select some fields it will give me the results. It seems to have to
> do with too much data in the row. I seem to be able to get around
> it by CASTING it to a smaller VARCHAR.
>
> eg. SELECT CAST(SEGMENT_TEXT_1 as VARCHAR(100)) ...

Maybe this has something to do with the 64k limit for the row, though you
should not be able to create such table anyway...

Roman