Subject Re: [ib-support] firebird insertion error
Author Michael Weissenbacher
> conn.setAutoCommit(false);
> stm = conn.prepareStatement("INSERT INTO INDEXKEY1
> VALUES(?,'DEPOSITO',1,1)"); //this is line number 302. The ERROR LINE.
> for(int c=1;c<100000;c++){
> stm.setInt(1,c);
double-check if you are closing the PreparedStatement!
also, you should not create a new PreparedStatement for every insert, create
it once and use it for all inserts. i'm sure your program will work flawless
then.

michael