db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Van Couvering (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-211) Network Server returns no result sets for a procedure call that returns no result
Date Thu, 23 Jun 2005 14:56:09 GMT
    [ http://issues.apache.org/jira/browse/DERBY-211?page=comments#action_12314331 ] 

David Van Couvering commented on DERBY-211:

>From the JDBC 3 spec, section we have

"If the type or number of results returned by a CallableStatement object are not
known until run time, the CallableStatement object should be executed with the
method execute. The methods getMoreResults, getUpdateCount, and
getResultSet can be used to retrieve all the results.
The method execute returns true if the first result is a ResultSet object and
false if it is an update count.
When the method execute returns true, the method getResultSet is called to
retrieve the ResultSet object. When execute returns false, the method
getUpdateCount returns an int. If this number is greater than or equal to zero, it
indicates the number of rows that were affected by the statement. If it is -1, it
indicates that there are no more results."

Although it's not explicitly clear, it seems to me the intent is that it should return no
results with an update count of zero.  I propose to change the embedded driver to behave this
way, making it consistent with the client driver and IMHO the intent of the spec.  My concern,
however, is that this is changing the behavior of an interface that has been around a bit
longer within Derby, and I would like to understand if anyone feels this will have a significant
impact on users.

> Network Server returns no result sets for a procedure call that returns no result
> ---------------------------------------------------------------------------------
>          Key: DERBY-211
>          URL: http://issues.apache.org/jira/browse/DERBY-211
>      Project: Derby
>         Type: Bug
>   Components: Network Server
>     Versions:
>     Reporter: Kathey Marsden

> For a call of a procedure with no dynamic results embedded 
> Cloudscape returns a one result, an update count of zero.  However, using the network
server no results are returned. We should be consistent.
> To reproduce 
> See call za() in lang/procedure.java test.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:

View raw message