Good example but, how do insert a row to this table from JDBC ? Using ij, it's just a matter of using the DEFAULT parameter, however, the JDBC preparedstatement class has no setDefault() method.
On Fri, 16 Sep 2005 20:18:04 -0700, "Ali Demir" <[EMAIL PROTECTED]> said: > Yes. For example: > > CREATE TABLE GROUPS( > ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (start with 0, > increment by 1), > NAME VARCHAR(25) NOT NULL, > DESCRIPTION VARCHAR(255), > PRIMARY KEY (ID) > ) > > Regards, > Suavi Demir > > At 06:52 PM 9/16/2005, you wrote: > >If I remember correctly, Oracle can define a column as being a > >"sequence", which is a garaunteed unique integer for each record. Can > >derby do this? A create table example would be nice. > >-- > > firstname lastname > > [EMAIL PROTECTED] > > -- firstname lastname [EMAIL PROTECTED] -- http://www.fastmail.fm - Access your email from home and the web
