[hibernate-issues] [JIRA] (HHH-16847) The project was started in response to Oracle Database 23c’s evolving requirements. Oracle Database 23c has a number of new capabilities, including improved BOOLEAN support. It was necessary to update the Hibernate’s Oracle Dialect.

Othmane Douida ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6258267... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMjk2YzYzMzFl... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-16847?atlOrigin=eyJpIjoiMjk2Yz... ) HHH-16847 ( https://hibernate.atlassian.net/browse/HHH-16847?atlOrigin=eyJpIjoiMjk2Yz... ) The project was started in response to Oracle Database 23c’s evolving requirements. Oracle Database 23c has a number of new capabilities, including improved BOOLEAN support. It was necessary to update the Hibernate’s Oracle Dialect. ( https://hibernate.atlassian.net/browse/HHH-16847?atlOrigin=eyJpIjoiMjk2Yz... ) Issue Type: Improvement Affects Versions: 6.2.5 Assignee: Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Components: hibernate-core Created: 26/Jun/2023 05:29 AM Labels: ORA-01791 core Priority: Major Reporter: Othmane Douida ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6258267... ) The most recent version of Oracle’s flagship product, Oracle Database 23c, contains a num- ber of new features, including improved BOOLEAN compatibility. The Oracle Dialect used by Hibernate, a crucial part of the framework that enables communication between the Hibernate application and the Oracle database, has to be updated as a result of these improvements. The old representation of the boolean should be updated when someone want to work with the new database 23c : for example in the columnType here is the type of BOOLEAN column : case BOOLEAN: // still, after all these years... return "number(1,0)"; also the castPattern method has this comment : /** * Oracle doesn't have any sort of {@link Types#BOOLEAN} * type or {@link Types#TIME} type, and its default behavior * for casting dates and timestamps to and from strings is just awful. */ so I’ll be working on these changes inside the OracleDialect.class including the methods : contributeTypes, getPreferredSqlTypeCodeForBoolean, registerColumnTypes, castPattern, columnType. ( https://hibernate.atlassian.net/browse/HHH-16847#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16847#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#100227- sha1:a102ba3 )