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] Created: (DERBY-1364) Client driver does not roll back the effects of a stored procedure when incorrectly invoked by executeQuery()/executeUpdate()
Date Thu, 01 Jun 2006 10:08:29 GMT
Client driver does not roll back the effects of a stored procedure when incorrectly invoked
by executeQuery()/executeUpdate()
-----------------------------------------------------------------------------------------------------------------------------

         Key: DERBY-1364
         URL: http://issues.apache.org/jira/browse/DERBY-1364
     Project: Derby
        Type: Bug

  Components: JDBC, Network Client  
    Versions: 10.2.0.0, 10.1.2.1    
    Reporter: Knut Anders Hatlen
    Priority: Minor
     Fix For: 10.2.0.0


When executing a stored procedure with executeQuery() and the proc
doesn't return exactly one result set, the query should fail and the
statement should be rolled back. Embedded does this correctly.

The client driver, however, does not roll back the statement, so the
effects of statements executed on nested connections in the stored
procedure are still visible. The reason for this is that the network
server executes the statement with execute() instead of
executeQuery(), so that it succeeds on the server. The client then
counts the number of result sets, and raises an exception if it is not
one, but it does not roll back the effects of the stored procedure.
verified that.)

The same problem exists for executeUpdate(). JCC also has these
problems.

-- 
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