Re: HSQLDB 2.6.1, Hibernate 5.4.30.Final, DDL statements reapplied at every restart

Thanks for the prompt feedback.

I've already tried different settings for hbm2ddl auto configuration.

If I got it right I should set it to "update": at every restart if there 
any changes in the models they will applied, otherwise not.

Still it tries to reapply every DDL statement as for creation even with 
this value or any other value I set (including "none" or not setting 
anything).

Btw, I tried the same application with H2 embedded in postgres mode and 
no hdm2ddl settings and I didn't face the same issue.

So I'd assume it is a problem on the HSQLDB side, not on hibernate. Do I 
miss anything?

Thanks


 > Hibernate is covered extensively at StackOverflow. For example:

 > 
https://stackoverflow.com/questions/438146/what-are-the-possible-values-of-the-hibernate-hbm2ddl-auto-configuration-and-wha/1689769#1689769

 > Regarding your HSQLDB settings, see if you really need
 > sql.lowercase_ident=true. This setting is only necessary if you are
 > using a database access library that assumes (like PostgreSQL) column
 > names in ResultSet are lowercase.

 > Fred