Well thanks for the reply, although I prefer to use the platform dependent way even if that sounds weird! I've taken care though to abstract all the methods in an interface and implement as needed. So I guess I'll just have to go the way Masoud Kalali suggested if I finally decide to switch to Derb
There are other ways of doing this, however each method has their own good
points or bad points.
One way you can do this is to create a counter table.
(This allows you to have multiple counters within a single table.)
Then you can write your own procedure that will fetch the value of the
counter
Thanks for the quick response!.I would rather not create a table as I have a generic code that updates the database tables(deletes, inserts, modifies tables) that works with the DB's metadata and a static declaration of all the DB schema that might change as the application's version changes. I wou
Yes It is supported , you can build a table with a field that will
automatically increment due to inserting data.
for example :
create table tinc{
idenCol integer not null generate always as identity,
}
also in case that you need sometimes to insert some values for the
identity field you
Hello all!I just found out about derby( through Java DB) and I would like to know if the feature of Oracle sequences(or Firebird generators) is supported in order to automatically retreive and store a unique number, is supported in any way?Thanks in advance.Panayiotis Vlissidis
Talk is cheap. Use
Panayiotis Vlissidis wrote:
> Hello all.
>
> I just found out about Derby(Java DB) and I was wondering if there is any
> support for
> sequences(generators) for automatic generation of a unique number?
Derby supports automatically generated "identity" columns. More
information is here:
http
Hello all. I just found out about Derby(Java DB) and I was wondering if there is any support for sequences(generators) for automatic generation of a unique number?Thanks in advance.Panayiotis Vlissidis
Love cheap thrills? Enjoy PC-to-Phone calls to 30+ countries for just 2ยข/min with Yahoo! Messe