Problem batching stored procedure calls using JDBC

[usenet]

Hi.

I have a DB2 stored procedure that I call using JDBC. Now I'm trying to
batch the call. This is done by the book:

stmt = connection.prep areCall(" ... ");

stmt.setString( 1, "foo");
stmt.addBatch() ;

stmt.setString( 1, "bar");
stmt.addBatch() ;

stmt.setString( 1, "baze");
stmt.addBatch() ;

stmt.executeBat ch();

It appears that the stored procedure only gets invoked once - so after
the above there's only one record in the table the SP writes to, namely
the first ("foo").

Using same methodology I can make batching of prepared staetments work
fine.

Any tips?

Thanks.

Morten