Allow namespacing (catalog/schema) rules per db object type

Description

We use identity generation with GenerationTyp.AUTO to support different DBMS (mssql and postgre) with a sequence generator for each Entity:

persistence.xml

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:

Environment

Hibernate Version: 5.0.7.Final
DBMS: MSSQL 2014
Wildfly 10.0.0.Final

Activity

Show:
Steve Ebersole
June 9, 2016, 3:18 PM

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).

Assignee

Unassigned

Reporter

Johannes Zinn

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure