HSQLDB integration tests fail when the MSSQL database is used [DATAJDBC-346]

[spring-projects-issues]

salim achouche opened DATAJDBC-346 and commented

Several HSQL based tests fail when the testsuite is executed with a MSSQL database:
Maven tests (Spring Data JDBC)
[ERROR] Errors: 

[ERROR]   ImmutableAggregateTemplateHsqlIntegrationTests.changeReferencedEntity » IllegalState

[ERROR]   ImmutableAggregateTemplateHsqlIntegrationTests.replaceReferencedEntity » IllegalState

[ERROR]   ImmutableAggregateTemplateHsqlIntegrationTests.saveAndDeleteAllWithReferencedEntity » IllegalState

[ERROR]   ImmutableAggregateTemplateHsqlIntegrationTests.saveAndDeleteAnEntityWithReferencedEntity » IllegalState

[ERROR]   ImmutableAggregateTemplateHsqlIntegrationTests.saveAndLoadAnEntityWithReferencedEntityById » IllegalState

[ERROR]   ImmutableAggregateTemplateHsqlIntegrationTests.saveAndLoadAnEntityWithReferencedNullEntity » IllegalState

[ERROR]   ImmutableAggregateTemplateHsqlIntegrationTests.saveAndLoadManyEntitiesByIdWithReferencedEntity » IllegalState

[ERROR]   ImmutableAggregateTemplateHsqlIntegrationTests.saveAndLoadManyEntitiesWithReferencedEntity » IllegalState

[ERROR]   ImmutableAggregateTemplateHsqlIntegrationTests.saveWithGeneratedIdCreatesNewInstance » IllegalState

[ERROR]   ImmutableAggregateTemplateHsqlIntegrationTests.updateReferencedEntityFromNull » IllegalState

[ERROR]   ImmutableAggregateTemplateHsqlIntegrationTests.updateReferencedEntityToNull » IllegalState

[ERROR]   JdbcRepositoryCrossAggregateHsqlIntegrationTests.savesAndRead » IllegalState F...

[ERROR]   JdbcRepositoryCrossAggregateHsqlIntegrationTests.savesAndUpdate » IllegalState

[ERROR]   JdbcRepositoryWithCollectionsAndManuallyAssignedIdHsqlIntegrationTests.deletingWithSet » IllegalState

[ERROR]   JdbcRepositoryWithCollectionsAndManuallyAssignedIdHsqlIntegrationTests.findAllLoadsCollection » IllegalState

[ERROR]   JdbcRepositoryWithCollectionsAndManuallyAssignedIdHsqlIntegrationTests.saveAndLoadEmptySet » IllegalState

[ERROR]   JdbcRepositoryWithCollectionsAndManuallyAssignedIdHsqlIntegrationTests.saveAndLoadNonEmptySet » IllegalState

[ERROR]   JdbcRepositoryWithCollectionsAndManuallyAssignedIdHsqlIntegrationTests.updateSet » IllegalState

[ERROR]   EnableJdbcAuditingHsqlIntegrationTests.auditForAnnotatedEntity:65->lambda$configureRepositoryWith$4:196 » BeanCreation

[ERROR]   EnableJdbcAuditingHsqlIntegrationTests.customAuditorAware:166->lambda$configureRepositoryWith$4:196 » BeanCreation

[ERROR]   EnableJdbcAuditingHsqlIntegrationTests.customDateTimeProvider:144->lambda$configureRepositoryWith$4:196 » BeanCreation

[ERROR]   EnableJdbcAuditingHsqlIntegrationTests.noAnnotatedEntity:122->lambda$configureRepositoryWith$4:196 » BeanCreation

[INFO] 
[ERROR] Tests run: 284, Failures: 0, Errors: 22, Skipped: 14
 

---

Affects: 1.0.5 (Lovelace SR5)

Referenced from: pull request #144, and commits ea089be, 1481803