I'm trying to do an update using Oracle JDBC api but it always returns me 0 irrespective whether a record is succesfully updated or not.I need to differentiate
between the successful update & unsuccessfull update.Basing on the result I need to perform some action
Is there any way I can differentiate whether a record is succesfully updated or not.
Later I tried with JDBC 2.0 for batch updates,the problem still persists this always returns -2 whether a record is succesfully updated or not
Request you to let me know if any of you have some kind solution for this,any help highly appreciated
Do you like to know how to produce a unsuccessfull update ? Create a unique constraint , or some NULL constraint and try to update the record , you would get unsuccessful udpate , for other case you should get positive integer.
getUpdateCount() would give you the results.
subject: JDBC Batch updates(Oracle jdbc api & jdbc2.0)