create table Company (id bigint generated by default as identity,location bigint not null, addressId bigint, email varchar(255), name varchar(255), phone1 varchar(255), phone2 varchar(255), primary key (id, location));
The above fails on H2 but runs on mysql if i rewrite it as create table Company (id bigint,location bigint not null, addressId bigint, email varchar(255), name varchar(255), phone1 varchar(255), phone2 varchar(255), primary key (id, location)); it works,but then i'll have to manage creating company id Can this be fixed -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
