org.cesecore.audit.SecurityEventsAuditorSessionBeanTest fails when running on the H2 database during SecurityEventsAuditorSessionBeanTest.setUpCryptoProvider() where it tries to invoke org.cesecore.audit.impl.integrityprotected.IntegrityProtectedAuditorSessionBean.deleteRows(AuthenticationToken, Date, Properties) for initial clean up.

This fails with an Exception that isn't present on the test client JVM which obscures the error:

javax.ejb.EJBTransactionRolledbackException: org.hibernate.hql.internal.ast.QuerySyntaxException: expecting EOF, found 'ORDER' near line 1, column 107 [DELETE FROM org.cesecore.audit.impl.integrityprotected.AuditRecordData a WHERE a.timeStamp <= :timeStamp0 ORDER BY a.sequenceNumber ASC]

And the root problem is that we do ORDER BY on a SQL DELETE query which makes no sense even if other databases kindly ignores or handles it.

This failure also leads to a failure for org.cesecore.audit.log.SecurityEventsLoggerSessionBeanTest.test05ExportGeneratedLogs(), since it will use the same call for deleting the logs after export.