Hi,
sometimes i get the following exception when i call exceuteUpdate on a PreapredStatement:
java.sql.SQLException: GDS exception: org.firebirdsql.gds.GDSException: conversion error from string "1432"
at org.firebirdsql.jdbc.FBPreparedStatement.internalExecute(FBPreparedStatement.java:491)
at org.firebirdsql.jdbc.FBPreparedStatement.executeUpdate(FBPreparedStatement.java:151)

There are some setString()-calls im my method, but i'm 100% sure that not with '1432'.
But it is possible that my id-column(type integer) has an highest entry with 1432.
In my insert statement i do insert.setInt(1, -999) on this id column.
I have an after insert trigger like this:
BEGIN
update t_rechnung set id_rechnung = (select max(id_rechnung) + 1 FROM t_rechnung) where
NEW.id_rechnung = id_rechnung;
END

I only get this on the table t_rechnung (only sometimes), but I've other tables that looks analog to t_rechnung (with id-column and after insert trigger) where i never gets this exception.

Some explanation ?

gruse
Carsten