Hi,
I have an issue with the
batch execution (executeBatch() method) of the CallableStatement. I use IBM DB2 V8.1 database. When i m doing the batch update with the CallableStatement which is obtained on the Stored Procedure call, the adding is done successfully. But the Execution is not happening as expected. Its executing only one row (mostly the first row in the batch). The database is having only one row inserted as the procedure is for inserting a row at a time.
Once it gets executed, i m able to get the batchcount correctly where it shows the total number of elements being processed while adding. But the execution does not take place.
If the same CallableStatement is obtained on the simple sql query (say in my case the INSERT statement), its working perfectly. But not on the Procedure. I am using WSAD 5.1 with db2java.zip. Can anyone help me please? I had looked into the
JDBC Driver Implementation as well the JDBC Support in the IBM site as well , but could not get the reqd info!
I myself had worked previously the same executeBatch() with Stored Procedures in SQL Server 2000 with no issues.
Any suggestions and immediate help is much appreciated!
Thanks,
Raghavan alias Saravanan M.