You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Bernd Ruehlicke (JIRA)" <de...@db.apache.org> on 2004/12/16 21:42:56 UTC
[jira] Created: (DERBY-103) Global Oracle/Axion style sequence generator
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;
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
Re: [jira] Created: (DERBY-103) Global Oracle/Axion style sequence
generator
Posted by Mike Matrigali <mi...@sbcglobal.net>.
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;
>
>
>
>
[jira] Updated: (DERBY-103) Global Oracle/Axion style sequence generator
Posted by "Mike Matrigali (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-103?page=all ]
Mike Matrigali updated DERBY-103:
---------------------------------
Component: SQL
Description:
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;
was:
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;
Environment:
> Global Oracle/Axion style sequence generator
> --------------------------------------------
>
> Key: DERBY-103
> URL: http://issues.apache.org/jira/browse/DERBY-103
> Project: Derby
> Type: Wish
> Components: SQL
> 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;
--
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
[jira] Commented: (DERBY-103) Global Oracle/Axion style sequence
generator
Posted by "Jan Treffkorn (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-103?page=comments#action_12413799 ]
Jan Treffkorn commented on DERBY-103:
-------------------------------------
This is a ko criteria - especially for OR-mapping layers. Please vote 4 it!
> Global Oracle/Axion style sequence generator
> --------------------------------------------
>
> Key: DERBY-103
> URL: http://issues.apache.org/jira/browse/DERBY-103
> Project: Derby
> Type: Wish
> Components: SQL
> 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;
--
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
[jira] Closed: (DERBY-103) Global Oracle/Axion style sequence
generator
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-103?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas closed DERBY-103.
-------------------------------
Resolution: Duplicate
Closing this as a duplicate of DERBY-712.
> Global Oracle/Axion style sequence generator
> --------------------------------------------
>
> Key: DERBY-103
> URL: https://issues.apache.org/jira/browse/DERBY-103
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Reporter: Bernd Ruehlicke
> Assignee: Suran Jayathilaka
>
> 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;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-103) Global Oracle/Axion style sequence generator
Posted by "Bernd Ruehlicke (JIRA)" <de...@db.apache.org>.
[ http://nagoya.apache.org/jira/browse/DERBY-103?page=comments#action_56793 ]
Bernd Ruehlicke commented on DERBY-103:
---------------------------------------
Of course it should also support code like
....
s = getConnection().createStatement();
String query = "select module_s, mySql.nextval from my_module";
r = s.executeQuery(query);
r.next();
String module_s = r.getString(1);
String new_s = r.getString(2);
...
> 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;
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
[jira] Assigned: (DERBY-103) Global Oracle/Axion style sequence
generator
Posted by "Suran Jayathilaka (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-103?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suran Jayathilaka reassigned DERBY-103:
---------------------------------------
Assignee: Suran Jayathilaka
> Global Oracle/Axion style sequence generator
> --------------------------------------------
>
> Key: DERBY-103
> URL: https://issues.apache.org/jira/browse/DERBY-103
> Project: Derby
> Issue Type: Wish
> Components: SQL
> Reporter: Bernd Ruehlicke
> Assignee: Suran Jayathilaka
>
> 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;
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.