db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: [jira] Created: (DERBY-449) importing data using SYSCS_UTIL.SYSCS_IMPORT_DATA generates wrong message
Date Fri, 08 Jul 2005 15:34:50 GMT
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: Bug
>   Components: Tools  
>     Versions: 10.0.2.1    
>  Environment: Solaris
>     Reporter: 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".
> 


Mime
View raw message