We use identity generation with GenerationTyp.AUTO to support different DBMS (mssql and postgre) with a sequence generator for each Entity:
Hibernate generates the following SQL for creating the sequence, but MSSQL doesn't support providing catalog name on sequence creation.
As result we receive the following Exception on wildfly startup:
Hibernate Version: 5.0.7.Final
DBMS: MSSQL 2014
This is only a bug if MSSQL did not support catalog overall. It does.
You are really asking for a new feature to handle applying schema/catalog differently based on the type of database object (TABLE, SEQUENCE, etc).