Subject | Re: [ib-support] firebird insertion error |
---|---|
Author | Michael Weissenbacher |
Post date | 2003-04-10T13:11:29Z |
> conn.setAutoCommit(false);double-check if you are closing the PreparedStatement!
> 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);
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