Package org.hibernate.annotations

Interface DialectOverride

@Incubating public interface DialectOverride
Allows certain annotations to be overridden in a given SQL Dialect.

For example, a Formula annotation may be customized for a given Dialect using the DialectOverride.Formula annotation. 

 @Formula(value = "(rate * 100) || '%'")
 @DialectOverride.Formula(dialect = MySQLDialect.class,
                          override = @Formula("concat(rate * 100, '%')"))
 @DialectOverride.Formula(dialect = DB2Dialect.class,
                          override = @Formula("varchar_format(rate * 100) || '%'"))
 @DialectOverride.Formula(dialect = OracleDialect.class,
                          override = @Formula("to_char(rate * 100) || '%'"))
 @DialectOverride.Formula(dialect = SQLServerDialect.class,
                          override = @Formula("ltrim(str(rate * 100, 10, 2)) + '%'"))
 @DialectOverride.Formula(dialect = SybaseDialect.class,
                          override = @Formula("ltrim(str(rate * 100, 10, 2)) + '%'"))
 private String ratePercent;

An annotation may even be customized for a specific range of versions of the dialect by specifying a DialectOverride.Version.

  • dialect specifies the SQL dialect to which the override applies,
  • sameOrAfter specifies that the override applies to all versions beginning with the given version, and
  • before specifies that the override applies to all versions earlier than the given version.

Since:
6.0