Subject Hello and first problem (arithmetic exception, numeric overflow, or string truncation)
Author Ihsiak
Hello everybody :)
After months of reading I finally decided to join :) Unfortunately I
desperately need some help.

I have two web applications that use jaybird 2.1.1, one of them uses
plain jdbc connections and second one utilizes hibernate/jpa. (Customer
runs these on tomcat on suse box). Both are connected to Firebird 1.5.x
database which is installed on Windows 2k box. Database is being filled
by Delphi programs (run on variety of Windows machines).

Both my web apps set charset to win1250, encoding is set to ISO8859_2
(plain jdbc version, because pages are encoded in ISO-8859-2) and
UNICODE_FSS (hibernate version, pages are encoded in UTF).

Now here's a real problem: occasionally (only on some rows) both apps
throws exceptions because of:
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544321.
arithmetic exception, numeric overflow, or string truncation

the only solution I have found up to now is to remove all national
characters from suspicious fields. I am going to do some testing, but I
am not sure will I find out when those rows gets "broken".

So my question is: Is there any general solution to such problems? What
may be broken? How to fix it...?