hi, I am using addBatch() & executeBatch(), i want to identify which execution among the batch has failed! is it possible? please explain. Note : I am using Oracle10g db and ojdbc14.jar [ May 15, 2007: Message edited by: pavan mane ]
Originally posted by pavan mane: i want to identify which execution among the batch has failed! is it possible?
It depends on what you mean by fail. If you mean failed to update anything, you can look at the result of executeBatch. It returns a count of updated rows for each statement. If you mean an actual SQLException, then no - there isn't a way to find out which statement caused it.