db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mark Holster (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-5151) Sequence without cache
Date Thu, 24 Mar 2011 21:22:05 GMT
Sequence without cache

                 Key: DERBY-5151
                 URL: https://issues.apache.org/jira/browse/DERBY-5151
             Project: Derby
          Issue Type: Improvement
          Components: SQL
            Reporter: Mark Holster
         Attachments: sequence-no-cache.patch

Currently, a sequence in Derby always uses a pre allocating cache. I'm working on an usecase
which requires a number to increase with a fixed value. The usecase fails after a restart
because of the pre allocating cache.

I've created a patch that adds the options CACHE | NO CACHE to the create sequence statement.
When no cache is provided, the pre allocating cache size will be set to 1, which results in
a "no cache sequence".
I've followed the CYCLE | NO CYCLE code as much as possible. Tested it in my own app and it
seems to work fine.

This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

View raw message