Hibernate Release Notes

Updated NuoDBDialect to indicate that:

Added lpad() and rpad() functions to pad a string with additional characters to reach a specified length. The padding character is optional. The default padding character is space.

Added the registerCustomFunctions() method to support custom functions. By default, the JPQL engine does not include any additional custom functions. To define and register custom functions, override the registerCustomFunctions() method in a subclass, add definitions of custom functions for your application, and include the custom function calls in JPQL queries.

public void registerCustomFunctions(
    SqmFunctionRegistry functionRegistry, TypeConfiguration typeConfiguration);

Added support for the sign() function in JPQL queries, for integer arguments only.

Added support for the SUPPRESS_VERSION_WARNING Java property. Set its value to true in the OS environment as an environment variable or as a Java System property to suppress the version warning printed when NuoDBDialect is created.

Improved the mapping of SQLException to JPAException for better error handling. For more information, see NuoDBDialect.NuoDbSQLExceptionConversionDelegate.

Updated NuoDBDialect to generate a warning if a lock-timeout hint is used with a positive timeout value since it is not supported in NuoDB. NOWAIT and SKIP_LOCKED are supported.

CHAR and NCHAR data types are now implemented as CHAR and NCHAR, respectively. In earlier releases, CHAR and NCHAR could optionally be implemented using the STRING column type. VARCHAR, NVARCHAR, LONGVARCHAR, and LONGNVARCHAR can optionally be implemented as STRING column types.

When an application updates the same entity in a database, and the entity is versioned, the application reports, "BatchUpdateException: update conflict in table" instead of "ObjectOptimisticLockingFailureException:". (13810)
The issue has been resolved.

A SQL query with an UPDATE clause could report, "multi-column value only allowed in comparison operators".
The issue has been resolved.

Supports Hibernate 6.1 and JPA 3.1.

Hibernate 6 requires Java 11, but Spring 6 and Spring Boot 3 require Java 17.

Improved NuoDBDialect to correctly indicates that NuoDB support subquery on mutating table. For more information, see Dialect.supportsSubqueryOnMutatingTable().

Added support for the sign() function in JPQL queries, for integer arguments only.

Added support for the SUPPRESS_VERSION_WARNING Java property. Set its value to true in the OS environment as an environment variable or as a Java System property to suppress the version warning printed when NuoDBDialect is created.

Improved the mapping of SQLException to JPAException for better error handling. For more information, see NuoDBDialect.NuoDbSQLExceptionConversionDelegate.

Updated NuoDBDialect to generate a warning if a lock-timeout hint is used with a positive timeout value since it is not supported in NuoDB. NOWAIT and SKIP_LOCKED are supported.

CHAR and NCHAR data types are now implemented as CHAR and NCHAR, respectively. In earlier releases, CHAR and NCHAR could optionally be implemented using the STRING column type. VARCHAR, NVARCHAR, LONGVARCHAR, and LONGNVARCHAR can optionally be implemented as STRING column types.

Fixes for UPDATE SKIP LOCKED and a few function definitions.

Adds uuid() function.

Refactored, commented and tidied NuoDBDialect class.

Supports Hibernate 5.4 and JPA 2.1, Hibernate 5.6 and JPA 2.2.

Adds support for NuoDB database query hints and FOR UPDATE SKIP LOCKED and FOR UPDATE NOWAIT.

Adds isValidJson() and jsonUnquote(), listagg() and rownum() functions.

Adds era(), quarter(), dayofweek(), dayofyear(), weekofmonth(), weekofyear() functions.

Supports Hibernate 5.4.

Enables mapping of String data-members to NuoDB’s STRING column type.

Removes direct dependency on Hibernate to avoid start up issues in Web/Application Server.

Renumbered to allow the Hibernate JAR to be released independently of the NuoDB database.

Last update for this version 20.0.2-hib5.