[hibernate-issues] [JIRA] (HHH-16320) Support H2's native json DDL type using custom 'format json' write expressions

Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNjU3NGY5ODg4... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16320?atlOrigin=eyJpIjoiNjU3NG... ) HHH-16320 ( https://hibernate.atlassian.net/browse/HHH-16320?atlOrigin=eyJpIjoiNjU3NG... ) Support H2's native json DDL type using custom 'format json' write expressions ( https://hibernate.atlassian.net/browse/HHH-16320?atlOrigin=eyJpIjoiNjU3NG... ) Issue Type: Improvement Assignee: Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) Created: 16/Mar/2023 03:08 AM Priority: Major Reporter: Marco Belladelli ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=637b480... ) At the moment SqlTypes.JSON columns are mapped to H2’s clob ddl type. With this change we want to make use of the built-in json ddl type, which requires a special syntax when writing values from strings: ? format json (see http://www.h2database.com/html/datatypes.html#json_type ( http://www.h2database.com/html/datatypes.html#json_type ) ). This syntax is also compatible with clob typed-columns, so this change shouldn’t break backwards compatibility. ( https://hibernate.atlassian.net/browse/HHH-16320#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16320#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#100217- sha1:d601792 )