Package org.hibernate.cfg

Interface DialectSpecificSettings

public interface DialectSpecificSettings
Settings used as fallback to configure aspects of specific Dialects when the boot process does not have access to a DatabaseMetaData object or its underlying JDBC Connection.

  • Field Details

    • ORACLE_AUTONOMOUS_DATABASE

      static final String ORACLE_AUTONOMOUS_DATABASE
      Specifies whether this database is running on an Autonomous Database Cloud Service.

      Ignored if Hibernate is able to determine this by querying the Oracle server at startup.

      See Also:
      Default Value:
      false

    • ORACLE_EXTENDED_STRING_SIZE

      static final String ORACLE_EXTENDED_STRING_SIZE
      Specifies whether MAX_STRING_SIZE is set to EXTENDED on Oracle.

      Ignored if Hibernate is able to determine the value of MAX_STRING_SIZE by querying the Oracle server at startup.

      See Also:
      Default Value:
      false

    • ORACLE_APPLICATION_CONTINUITY

      static final String ORACLE_APPLICATION_CONTINUITY
      Specifies whether this database is accessed using a database service protected by Application Continuity.

      Ignored if Hibernate is able to determine this by querying the Oracle server at startup.

      See Also:
      Default Value:
      false

    • ORACLE_USE_BINARY_FLOATS

      static final String ORACLE_USE_BINARY_FLOATS
      Specifies whether the dialect should use the binary IEEE Oracle SQL types binary_float/binary_double over float(p)/real/double precision when generating DDL or SQL casts for float types.
      Since:
      7.0
      See Also:
      Default Value:
      true

    • ORACLE_OSON_DISABLED

      static final String ORACLE_OSON_DISABLED
      Specifies whether usage of the Oracle JSON binary format (also known as OSON) should be disabled.

      Starting in 21c, if the ojdbc-provider-jackson-oson extension is available, JSON data in an oracle database is stored using the OSON binary format. This setting can be used to fallback to the old implementation based on String serialization.

      Since:
      7.0
      See Also:
      Default Value:
      false

    • SYBASE_ANSI_NULL

      static final String SYBASE_ANSI_NULL
      Specifies whether the ansinull setting is enabled on Sybase.

      Ignored if Hibernate is able to determine the value of ansinull by querying the server @@options at startup.

      See Also:
      Default Value:
      false

    • SYBASE_PAGE_SIZE

      static final String SYBASE_PAGE_SIZE
      Specifies the maximum page size on Sybase.

      Ignored if Hibernate is able to determine the page size by querying the server @@maxpagesize at startup.

      See Also:
      Default Value:
      16384

    • MYSQL_BYTES_PER_CHARACTER

      static final String MYSQL_BYTES_PER_CHARACTER
      Specifies the bytes per character to use based on the database's configured charset.

      Ignored if Hibernate is able to determine the character set by querying the server @@character_set_database at startup.

      See Also:
      Default Value:
      4

    • MYSQL_NO_BACKSLASH_ESCAPES

      static final String MYSQL_NO_BACKSLASH_ESCAPES
      Specifies whether the NO_BACKSLASH_ESCAPES sql mode is enabled.

      Ignored if Hibernate is able to determine this by querying the server @@sql_mode at startup.

      See Also:
      Default Value:
      false

    • COCKROACH_VERSION_STRING

      static final String COCKROACH_VERSION_STRING
      Specifies a custom CockroachDB version string. The expected format of the string is the one returned from the version() function, e.g.: "CockroachDB CCL v23.1.8 (x86_64-pc-linux-gnu, built 2023/08/04 18:11:44, go1.19.10)"

      Ignored if Hibernate is able to obtain the version string by querying the server at startup.

      See Also:

    • SQL_SERVER_COMPATIBILITY_LEVEL

      static final String SQL_SERVER_COMPATIBILITY_LEVEL
      Specifies the compatibility level of the SQL Server database as returned by select compatibility_level from sys.databases.

      The number has three digits: the first two digits are the major version, the last digit is the minor version.

      Ignored if Hibernate is able to determine this by querying the sys.databases table at startup.

      See Also:

    • HANA_MAX_LOB_PREFETCH_SIZE

      static final String HANA_MAX_LOB_PREFETCH_SIZE
      Specifies the LOB prefetch size. LOBs larger than this value will be read into memory as the HANA JDBC driver closes the LOB when the result set is closed.

      Ignored if Hibernate is able to determine this by querying the server at startup.

      See Also:
      Default Value:
      1024