db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3687) Make client driver allow nested savepoints
Date Thu, 22 May 2008 23:09:55 GMT

    [ https://issues.apache.org/jira/browse/DERBY-3687?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12599237#action_12599237
] 

Dag H. Wanvik commented on DERBY-3687:
--------------------------------------

I checked the standard, and SQL savepoints do allow nesting, cf. section 4.35.2 in ISO/IEC
9075-2:2003:

"An SQL-transaction has one or more savepoint levels, exactly one of which is the current
savepoint level. The
savepoint levels of an SQL-transaction are nested, such that when a new savepoint level NSL
is established,
the current savepoint level CSL ceases to be current and NSL becomes current. When NSL is
destroyed, CSL
becomes current again."

So the standard is not prohibiting this functionality in SQL. Then what is the reason?


> Make client driver allow nested savepoints
> ------------------------------------------
>
>                 Key: DERBY-3687
>                 URL: https://issues.apache.org/jira/browse/DERBY-3687
>             Project: Derby
>          Issue Type: Improvement
>          Components: Network Client
>            Reporter: Dag H. Wanvik
>
> Currently, only the embedded driver allows nested savepoints, cf. the attached repro.
> In the interest of harmonizing the drivers it would be nice to make the client driver
allow this as well.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message