db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-1314) Differences between client and embedded when invoking stored procedures using Statement.executeUpdate()
Date Tue, 13 Jun 2006 11:51:30 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1314?page=all ]

Knut Anders Hatlen updated DERBY-1314:
--------------------------------------

    Derby Info: [Patch Available, Release Note Needed]

Proposal for release note (DERBY-501 and DERBY-1314):

The behaviour of executeQuery() and executeUpdate() has been modified
to follow the JDBC standard when executing stored procedures. For the
embedded driver, this means that

  a) it is now possible to use executeQuery() to execute a stored
     procedure that returns exactly one ResultSet (this would fail in
     previous releases of Derby)

  b) executeUpdate() will raise an exception if it is used to execute
     a stored procedure that returns one or more ResultSets (this
     would succeed in previous releases of Derby)

For the client driver, the following has changed:

  a) PreparedStatement.executeUpdate() will raise an exception if it
     is used to execute a stored procedure that returns one or more
     ResultSets (previously, it would succeed, whereas Statement and
     CallableStatement correctly raised an exception)

  b) executeUpdate() will return 0 when executing a stored procedure
     which doesn't return a ResultSet (previously it would return -1)

> Differences between client and embedded when invoking stored procedures using Statement.executeUpdate()
> -------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-1314
>          URL: http://issues.apache.org/jira/browse/DERBY-1314
>      Project: Derby
>         Type: Bug

>   Components: JDBC
>     Versions: 10.2.0.0
>     Reporter: Knut Anders Hatlen
>     Assignee: Knut Anders Hatlen
>  Attachments: derby-1314-v1.diff, derby-1314-v1.stat
>
> When invoking a stored procedure using Statement.executeUpdate(), the
> client driver and the embedded driver behave differently.
> If the stored procedure does not return any result set, the embedded
> driver returns 0, whereas the client returns -1.
> If the stored procedure returns one or more result sets, the embedded
> driver returns -1, whereas the client fails with an exception.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message