Fix tests failing when switching to Oracle

Description

When running tests against Oracle:

1 gradle clean test -Pdb=oracle

The following tests fail:

  1. documentation

    1 2 3 4 5 DatabaseMultiTenancyTest. testBasicExpectedBehavior SchemaMultiTenancyTest. classMethod CollectionLoaderTest. test_HHH10557 CustomSQLSecondaryTableTest. test_sql_custom_crud CustomSQLTest. test_sql_custom_crud
  2. hibernate-core

    1 2 3 4 5 6 7 8 9 10 11 12 13 IndexedCollectionTest. testTemporalKeyMap EagerIndexedCollectionTest. testTemporalKeyMap MapKeyAttributeConverterTest. classMethod InheritanceManyToManyForeignKeyTest. testForeignKeyNameUnicity BulkManipulationTest. testDeleteOnJoinedSubclass BulkManipulationTest. testUpdateOnMammal BulkManipulationTest. testUpdateSetNullOnJoinedSubclass UUIDBasedIdInterpretationTest. testBinaryRuntimeUsage OneToManyTest. testOneToManyLinkTable SchemaExportTest. testBothType SchemaUpdateFormatterTest. testSetFormat CrossSchemaForeignKeyGenerationTest. testSchemaMigrationForeignKeysAreGeneratedAfterAllTheTablesAreCreated InheritanceSchemaUpdateTest. testBidirectionalOneToManyReferencingRootEntity
  3. hibernate-entitymanager

    1 QueryLockingTest. testEntityLockModeStateAfterQueryLocking
  4. hibernate-envers

  5.  

    1 2 3 4 5 6 7 8 AssociationToOneQueryTest. initData[0] AssociationToOneQueryTest. initData[1] AssociationToOneQueryTest. testAssociationQueryWithOrdering[0] AssociationToOneQueryTest. testAssociationQueryWithOrdering[1] AssociationToOneQueryTest. testAssociationQueryWithProjection[0] AssociationToOneQueryTest. testAssociationQueryWithProjection[1] AssociationToOneQueryTest. testAssociationQuery[0] AssociationToOneQueryTest. testAssociationQuery[1]

Environment

None

Status

Assignee

Vlad Mihalcea

Reporter

Vlad Mihalcea

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Affects versions

5.1.0

Priority

Major