- it doesn't seem this is possible.
How else are we supposed to insert default data into our derby databases? Consider 3 tables for instance:
(Author) 1-M (Author_Book) (M-1 Book)
The ID's for author and book will eventually become identity keys starting with 100, increment by 1.
I want a way to setup the tables without having the start with 100 or increment by 1, so I can enter some sample data, and then modify the column to start with 100 and increment by 1 so later everything is handled automatically.
Is this impossible with derby? If so, do I have any other similar answers?