We use identity generation with GenerationTyp.AUTO to support different DBMS (mssql and postgre) with a sequence generator for each Entity:
persistence.xml
If I start wildfly and it tries to create tables, sequences, etc. mssql, I get the following exception.
Exception on wildfly startup:
Possible workarounds:
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
Wildfly 10.0.0.Final
This issue is still present in Hibernate 5.4.12.Final and MSSQL 2016 / MSSQL 2017 for linux.
I have prepared a github repo with a test case for this issue. The problems are better explained in HHH-10882.