[hibernate-issues] [JIRA] (HHH-15504) Add UUID support for SQL Server 2008

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMWMyNDMyZWE4... ) / New Feature ( https://hibernate.atlassian.net/browse/HHH-15504?atlOrigin=eyJpIjoiMWMyND... ) HHH-15504 ( https://hibernate.atlassian.net/browse/HHH-15504?atlOrigin=eyJpIjoiMWMyND... ) Add UUID support for SQL Server 2008 ( https://hibernate.atlassian.net/browse/HHH-15504?atlOrigin=eyJpIjoiMWMyND... ) Issue Type: New Feature Assignee: Unassigned Components: hibernate-core Created: 13/Sep/2022 01:46 AM Fix Versions: 6.2.0 Priority: Major Reporter: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Add support for the uniqueidentifier data type in the SQLServerDialect for UUID, which is supported at least since SQL Server 2008. Since the minimum version is 10 now, which is for SQL Server 2008, we can safely add that type unconditionally. Also see https://docs.microsoft.com/en-us/sql/t-sql/data-types/uniqueidentifier-tr... ( https://docs.microsoft.com/en-us/sql/t-sql/data-types/uniqueidentifier-tr... ) We might need a custom JdbcType though to bind the bytes in the right order. Also see https://hibernate.atlassian.net/browse/HHH-15306 ( https://hibernate.atlassian.net/browse/HHH-15306 ) Also, check out if the JDBC driver reports some funky JDBC type code for this DDL type and if so, map that type code to our UUID code. Also, mention the change of SQL types in the migration guide, with a reference to the config setting that allows controlling the SQL type. ( https://hibernate.atlassian.net/browse/HHH-15504#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15504#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100206- sha1:821f494 )