MS SQL 2016 with SQLServer2012Dialect not working properly

[msavy]

We use MS SQL 2016 with SQLServer2012Dialect.

The problem is in Metadata parsing process. The first mistake was that the mssql11 ddl's missing metadata table creation
-- Changeset c:/Users/ewittman/git/apiman/apiman/distro/ddl/src/main/liquibase/current/010-apiman-manager-api.db.tables.changelog.xml::1436469846462-24::apiman (generated) CREATE TABLE [metadata] (id bigint NOT NULL, exported_on datetime, imported_on datetime, apiman_version VARCHAR(255), apiman_version_at_import VARCHAR(255), success [bit]);

After fixing this we move a little bit but still ending with the same exception.

The following rows are from MS SQL configuration

2021-06-14 16:44:55,768 TRACE [org.hibernate.engine.jdbc.env.internal.NormalizingIdentifierHelperImpl] (default task-1) Normalizing identifier quoting for object name [users]
2021-06-14 16:44:55,768 TRACE [org.hibernate.engine.jdbc.env.internal.NormalizingIdentifierHelperImpl] (default task-1) Rendering unquoted identifier [users] in mixed case for use in DatabaseMetaData
2021-06-14 16:44:55,768 TRACE [org.hibernate.engine.jdbc.env.internal.NormalizingIdentifierHelperImpl] (default task-1) Normalizing identifier quoting for object name [username]
2021-06-14 16:44:55,768 TRACE [org.hibernate.engine.jdbc.env.internal.NormalizingIdentifierHelperImpl] (default task-1) Rendering unquoted identifier [username] in mixed case for use in DatabaseMetaData
2021-06-14 16:44:55,768 TRACE [org.hibernate.engine.jdbc.env.internal.NormalizingIdentifierHelperImpl] (default task-1) Normalizing identifier quoting for object name [email]
2021-06-14 16:44:55,768 TRACE [org.hibernate.engine.jdbc.env.internal.NormalizingIdentifierHelperImpl] (default task-1) Rendering unquoted identifier [email] in mixed case for use in DatabaseMetaData
2021-06-14 16:44:55,768 TRACE [org.hibernate.engine.jdbc.env.internal.NormalizingIdentifierHelperImpl] (default task-1) Normalizing identifier quoting for object name [full_name]
2021-06-14 16:44:55,768 TRACE [org.hibernate.engine.jdbc.env.internal.NormalizingIdentifierHelperImpl] (default task-1) Rendering unquoted identifier [full_name] in mixed case for use in DatabaseMetaData
2021-06-14 16:44:55,768 TRACE [org.hibernate.engine.jdbc.env.internal.NormalizingIdentifierHelperImpl] (default task-1) Normalizing identifier quoting for object name [joined_on]
2021-06-14 16:44:55,768 TRACE [org.hibernate.engine.jdbc.env.internal.NormalizingIdentifierHelperImpl] (default task-1) Rendering unquoted identifier [joined_on] in mixed case for use in DatabaseMetaData
2021-06-14 16:44:55,768 DEBUG [org.hibernate.internal.SessionFactoryImpl] (default task-1) HHH000031: Closing
2021-06-14 16:44:55,768 TRACE [org.hibernate.engine.query.spi.QueryPlanCache] (default task-1) Cleaning QueryPlan Cache
2021-06-14 16:44:55,768 TRACE [org.hibernate.type.spi.TypeConfiguration$Scope] (default task-1) Handling #sessionFactoryClosed from [org.hibernate.internal.SessionFactoryImpl@42fa9f7d] for TypeConfiguration

And this lines comes from PostgreSQL configuration

2021-06-14 15:26:02,725 TRACE [org.hibernate.engine.jdbc.env.internal.NormalizingIdentifierHelperImpl] (default task-1) Normalizing identifier quoting for object name [users]
2021-06-14 15:26:02,725 TRACE [org.hibernate.engine.jdbc.env.internal.NormalizingIdentifierHelperImpl] (default task-1) Rendering unquoted identifier [users] in lower case for use in DatabaseMetaData
2021-06-14 15:26:02,725 TRACE [org.hibernate.engine.jdbc.env.internal.NormalizingIdentifierHelperImpl] (default task-1) Normalizing identifier quoting for object name [username]
2021-06-14 15:26:02,725 TRACE [org.hibernate.engine.jdbc.env.internal.NormalizingIdentifierHelperImpl] (default task-1) Rendering unquoted identifier [username] in lower case for use in DatabaseMetaData
2021-06-14 15:26:02,725 TRACE [org.hibernate.engine.jdbc.env.internal.NormalizingIdentifierHelperImpl] (default task-1) Normalizing identifier quoting for object name [email]
2021-06-14 15:26:02,725 TRACE [org.hibernate.engine.jdbc.env.internal.NormalizingIdentifierHelperImpl] (default task-1) Rendering unquoted identifier [email] in lower case for use in DatabaseMetaData
2021-06-14 15:26:02,725 TRACE [org.hibernate.engine.jdbc.env.internal.NormalizingIdentifierHelperImpl] (default task-1) Normalizing identifier quoting for object name [full_name]
2021-06-14 15:26:02,725 TRACE [org.hibernate.engine.jdbc.env.internal.NormalizingIdentifierHelperImpl] (default task-1) Rendering unquoted identifier [full_name] in lower case for use in DatabaseMetaData
2021-06-14 15:26:02,725 TRACE [org.hibernate.engine.jdbc.env.internal.NormalizingIdentifierHelperImpl] (default task-1) Normalizing identifier quoting for object name [joined_on]
2021-06-14 15:26:02,725 TRACE [org.hibernate.engine.jdbc.env.internal.NormalizingIdentifierHelperImpl] (default task-1) Rendering unquoted identifier [joined_on] in lower case for use in DatabaseMetaData
2021-06-14 15:26:02,725 TRACE [org.hibernate.service.internal.AbstractServiceRegistryImpl] (default task-1) Initializing service [role=org.hibernate.engine.transaction.jta.platform.spi.JtaPlatform]
2021-06-14 15:26:02,725 DEBUG [org.hibernate.query.spi.NamedQueryRepository] (default task-1) Checking 0 named HQL queries
2021-06-14 15:26:02,725 DEBUG [org.hibernate.query.spi.NamedQueryRepository] (default task-1) Checking 0 named SQL queries
2021-06-14 15:26:02,725 TRACE [org.hibernate.type.spi.TypeConfiguration$Scope] (default task-1) Handling #sessionFactoryCreated from [org.hibernate.internal.SessionFactoryImpl@87f2e15] for TypeConfiguration
2021-06-14 15:26:02,741 DEBUG [org.hibernate.internal.SessionFactoryRegistry] (default task-1) Initializing SessionFactoryRegistry : org.hibernate.internal.SessionFactoryRegistry@1635f168
2021-06-14 15:26:02,741 DEBUG [org.hibernate.internal.SessionFactoryRegistry] (default task-1) Registering SessionFactory: 67f714bc-fb82-4b16-92ca-3e9fd001a68f (<unnamed>)

It looks like something wrong is still with metadata processing.

Thank you

Jan

Originally posted by @radlik01 in #1304 (reply in thread)

[msavy]

BTW @radlik01 if you have any fuller stack traces that would be helpful when we get time to look. If you don't then that's fine.

[radlik01]

Dear all,

do you have any plan for fixing this issue ?

Thank you

Jan

[msavy]

Good morning, Jan! Yes, it's certainly on my radar, but currently I am focusing on some issues and features a sponsor has requested.

[radlik01]

Dear all,

any news ?

Thank you
Jan

[msavy]

Dear all,

any news ?

Thank you Jan

Hi @radlik01,

I'm still working very hard on a customer project, and haven't had the bandwidth to look at this yet. However, on the 3.x branch I've been trying to migrate to a newer version of MSSQL DDL.

If you can email me on marc@blackparrotlabs.io we can have a discussion so I can understand your specific deployment situation a bit better and ensure I address that when I have an opportunity.