I believe you are going to find that ij was never designed to determine the difference between update/delete/insert. ij tries to not parse the SQL it is executing, it just packages it up and sends it the server. It is going to treat procedure execution the same, and I don't know if procedures can return row counts.
It either gets a row count back from the server - in which case it prints the update/delete/insert message. Or it gets a result set back and does the standard row printing that a select shows. simmi iyer (JIRA) wrote:
importing data using SYSCS_UTIL.SYSCS_IMPORT_DATA generates wrong message ------------------------------------------------------------------------- Key: DERBY-449 URL: http://issues.apache.org/jira/browse/DERBY-449 Project: Derby Type: BugComponents: Tools Versions: 10.0.2.1 Environment: SolarisReporter: simmi iyer 1. Launch ij to connect to Derby using embedded driver. 2. Issue following command at ij prompt CALL SYSCS_UTIL.SYSCS_IMPORT_DATA(......); 3. Even if several rows have been imported, at the end of import following message is given 0 rows inserted/updated/deleted There are 2 issues: 1. The message is misleading. Even if several rows got inserted with import, the message indicates 0. 2. The message should not only indicate how many rows got imported successfully but also how many got rejected. This first problem seems to be only with embedded driver. Using Network Client driver to gives a more acceptable message "Statement executed".
