db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: [jira] Created: (DERBY-103) Global Oracle/Axion style sequence generator
Date Thu, 16 Dec 2004 23:59:54 GMT
could you add details on what you would expect from such a
feature.  The usual problem with such a feature is what
do you want the system to do with the number generator and
transactions.  Does it allow holes by committing the generation
of a sequence number separate from the transaction which allocated
the number or does it lock out other
transactions until a transaction allocating the number
commits.



Bernd Ruehlicke (JIRA) wrote:

> Global Oracle/Axion style sequence generator
> --------------------------------------------
> 
>          Key: DERBY-103
>          URL: http://nagoya.apache.org/jira/browse/DERBY-103
>      Project: Derby
>         Type: Wish
>     Reporter: Bernd Ruehlicke
> 
> 
> The identity column generator is just not enought. It would just be wonderful if Derby
had commands like
> 
> CREATE SEQUENCE mySeq;
> 
> values mySeq.nextval;
> values mySeq.currval;
> 
> CREATE TABLE my_table (
>     id integer default mySeq.nextval,
>     value varchar(40)
> )
> 
> DROP SEQUENCE mySeq;
> 
> 
> 
> 

Mime
View raw message