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

Try without the hbm2ddl setting for Hibernate, and without sql.lowercase_ident=true for HSQLDB.

On Sun, Nov 7, 2021, at 11:34, Andrea Spacca wrote:
> 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
>
>
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user