Gustaf Andersson wrote:
> Dmitry Melekhov wrote:
> >
> > Hello!
> >
> > I want to have entity beans with server generated unique primary keys.
> > Now I write bean managed persistent beans with Sybase identity fields.
> > But this beans would not work with other servers.
> > How to generate autoincrement primary keys?
> >
> > --
> > Dmitry Melekhov
> > http://www.aspec.ru/~dm
> > 2:5050/11.23@fidonet
>
> I dont know about sybase, but in oracle you create a sequence.
>
> Example syntax:
>
> CREATE SEQUENCE your_seq_name
> INCREMENT BY 1
> START WITH 1
> NOMAXVALUE
> NOCYCLE;
>
> Example usage:
>
> SELECT your_seq_name.NEXTVALUE FROM DUAL;
>
> SELECT your_seq_name.CURRVALUE FROM DUAL;
>
> I dont know how Sybase solved this, but I hope this will help you.
>
> /Gustaf
I know about this for Oracle and about identity fields for Sybase,
but this is RDBMS specific.
Now we use Sybase, but may be somewhere we will move to
another database.
--
Dmitry Melekhov
http://www.aspec.ru/~dm
2:5050/11.23@fidonet
