executeUpdate() return

[sumit gandhi]

Hi,
Need your help on this one.I am using PreparedStatment to update the database records.Now, I want to throw Application exception on the basis of returned value from executeUpdate(). What should be the condition to throw exception?
int intReturn = pstmtUpdate.executeUpdate();
if (intReturn ??? 0) {
<Success>}
else {
<throw exception>
}
??? in above condition should be >,>= . Please respond.}

[Medha Jhunjhunwala]

intReturn will have the number of rows updated. So, if you think that updation of 0 rows is an exception, then use intReturn > 0 as success condition.

http://java.sun.com/j2se/1.4.2/docs/api/java/sql/PreparedStatement.html#executeUpdate()

-Medha

[Abhishek Asthana]

Maybe you can make use of 'execute' in place of executeUpdate.

[sumit gandhi]

Thanks Medha and Abhishek for your responses.