Batch job with jdbc produce -805

[bhu]

Hi all,

We have to insert ~200.000 rows in a db2 (zos) table.

Because of too many records without commit, we prefered work with a little program and commit each inserts (or n inserts).

So we found this JZOS tool, install it and try.
It works fine and we are happy for the future to be able to launch batch java jobs !

Problem : the java batch job works fine but after ~1.000 inserts it produce a -805 (bind error) SQLException !
Program : java, jdbc (not batch jdbc), driver type 4

Have someone experience with this ?
Haven't we understood the right idea of the jzos tool ?
This message is perhaps not in the right forum, but maybe someone could help ?

Thanks !
Ben

[orr94]

You should be able to do what you are describing, as long as everything is done properly. Can you give the full stack trace for the SQLException? It ought to show the SQLSTATE, which would be helpful.

Providing the critical section of the code would also help us out. It's possible you aren't closing your Statements/ResultSets after using them (or aren't reusing your PreparedStatements).

[bhu]

Yes, it was that : statment not closed !
Now it work fine !

Thanks.