Hello, Last year I posted a problem in old forum and created HHH-12106 which should habe been fixed in hibernate 5.3.1-final according to the versions’ change log. The problem was that a database name containing a hyphen in Microsoft SQL-Server is not quoted at hibernate schema update. I tested it …

We have the SqlServerQuoteSchemaTest that works just fine.

I see in test property hibernate.globally_quoted_identifiers=true is set. Do you confirm that this property has to be used in general (javadoc: Should all database identifiers be quoted) just because one identifier (in this case the database name) should be quoted? I used it also, but it still does…

Try to supply a Pull Request which replicates your issue.

I can reproduce it with SqlServerQuoteSchemaTest when using MS-SQL-Server 2008 and appropriate Dialect org.hibernate.dialect.SQLServer2008Dialect which is very old of course. Then the update DDL contains the unquoted database name: alter table serie-m.[my-schema].[my_entity] add [title]…

In the DDL to CREATE the table the catalog name is not used in despite to the update DDL: create table [paul].[my_entity] ( [id] int not null, primary key ([id]) ) alter table seriem.[paul].[my_entity] add [title] varchar(255)

But why do you need the database name in your qualified name? The database can be implied from the JDBC URL string: jdbc:sqlserver://localhost;instance=SQLEXPRESS;databaseName=hibernate_orm_test

Thanks for the hint. But after I added the database name to the JDBC URL it still appears in the DDL: my URL: hibernate.connection.url=jdbc:sqlserver://mssql-2008-std.hq.kwsoft.de:1433;instance=MSSQL-2008-STD;databaseName=serie-m DDL statement: alter table serie-m.[paul].[my_entity] add [tit…

Sends us a Pull Request which replicates the issue based on the ones we have committed previously. We will investigate it afterwards.

Puh, a lot of work for me for what you already have resp. could adapt easily. Simply run SqlServerQuoteSchemaTest against your MS-SQL-Server and you should see the non-quoted database name in the full qualified entity name in the “alter table add columns” DDL statement. Still want me to send a pull…

Fix HHH-12106 Database name not quoted at schema update on MS-SQLServer not working

Hibernate ORM

vlad June 14, 2018, 6:24am 12

Any change to the codebase must have an associated test case. We need the test case to see the impact on other databases as well.

Topic		Replies	Views
Hibernate does not support database name containing a dash (e.g. my-db) sign when using MySQL Hibernate ORM	5	5799	April 18, 2024
With Hibernate 6 table and column name are not correctly coming in SQL Hibernate ORM	8	4135	February 1, 2024
Hibernate fails to create a table with title "schema" or "condition" Hibernate ORM	1	358	February 7, 2022
"Version" table name is not escaped with SchemaExport Hibernate ORM	5	585	November 24, 2021
Hibernate: Can't insert a row using “identity” id generation with qouted column name Hibernate ORM	1	697	June 8, 2018

Fix HHH-12106 Database name not quoted at schema update on MS-SQLServer not working

Related topics