We use identity generation with GenerationTyp.AUTO to support different DBMS (mssql and postgre) with a sequence generator for each Entity:
If I start wildfly and it tries to create tables, sequences, etc. mssql, I get the following exception.
Exception on wildfly startup:
define the catalog in persistence.xml with
But if I do this I run into another bug, I described in
This issue is also already discussed in hibernate forum: https://forum.hibernate.org/viewtopic.php?f=1&t=1043232
use create instead of update for hbm2ddl in persistence.xml
But this isn't practical during development.
Hibernate Version: 5.0.7.Final
DBMS: MSSQL 2014