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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.