HSQLDB Identity start with 1

Support
#1

Hi,

Can you make Identity field auto increment start with 1 for database HSQLDB, default it start with 0. So I cannot modify first record, the platform show error entity is modified in another transaction.

Thanks.

#2

Hi,

I’ve created an issue: https://youtrack.cuba-platform.com/issue/STUDIO-3974
However, I would recommend using HSQL only for prototyping and switch to another DBMS as soon as you start writing any real application.

1 Like
#3

Thanks Konstantin.

Another error is when I create entity with Identity primary key, the CollectionDatasource<Entity, IdProxy> in browser screen must be replaced with CollectionDatasource<Entity, IdProxy> manually.

#4

It’s already fixed for Studio 6.6.2, which will be available soon: https://youtrack.cuba-platform.com/issue/STUDIO-3954

1 Like