Subject | Re: [Firebird-Java] Mac OSX and Varchar |
---|---|
Author | Roman Rokytskyy |
Post date | 2005-02-16T08:28:20Z |
> I am porting an application from Windows to Mac OSX. I ran into aCan you post complete stack trace?
> few database converstion issues I have gotton around, but my newest
> issue is the following:
>
> org.firebirdsql.FBSQLException: Resource Exception. Unrecognized
> transaction.
> 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 onlyMaybe this has something to do with the 64k limit for the row, though you
> 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)) ...
should not be able to create such table anyway...
Roman