executeUpdate() returning not the correct row count with JDBC driver 1.2
executing a delete statement with executeUpdate() and in the database a delete trigger is executed and the trigger executes a stored procedure:
With JDBC Driver 1.1:
- executeUpdate() returns always 1
With JDBC Driver 1.2:
- When the stored procedure does update no records the executeUpdate() return 0
- When the stored procedure does update records the executeUpdate() returns the amount of records updated by the stored procedure.
This problem occurs with SQL server 2005 as with SQL server 2008