Created attachment 753915 [details] mssql and oracle stacktraces from jenkins job org.jbpm.persistence.correlation.CorrelationPersistenceTest fails on oracle11gR2 and mssql2008R2. MS SQL 2008 R2: org.hibernate.exception.SQLGrammarException: Column 'CorrelationKeyInfo.processInstanceId' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/Drools%20jBPM/view/All/job/jbpm-persistence-db-matrix/DATABASE=mssql2008R2,MODULES=jbpm-persistence-jpa,jdk=java16_default,label=RHEL_any/lastCompletedBuild/testReport/org.jbpm.persistence.correlation/CorrelationPersistenceTest/testCreateCorrelation/ Oracle 11g R2: org.hibernate.exception.SQLGrammarException: ORA-00979: not a GROUP BY expression https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/Drools%20jBPM/view/All/job/jbpm-persistence-db-matrix/DATABASE=oracle11gR2,MODULES=jbpm-persistence-jpa,jdk=java16_default,label=RHEL_any/lastCompletedBuild/testReport/org.jbpm.persistence.correlation/CorrelationPersistenceTest/testCreateCorrelation/ All three CorrelationPersistenceTest fails on these databases. On MySQL and PostgreSQL these tests are passing without problems. Whole stacktraces are attached to this bugzilla. The build was run against jbpm master on 2013-05-25. To reproduce either configure jbpm test suite to use Oracle/MS SQL databases or use https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/Drools%20jBPM/view/All/job/droolsjbpm-persistence-db-single/
The issue has been verified: https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/Drools%20jBPM/view/All/job/droolsjbpm-persistence-db-single/12/ https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/Drools%20jBPM/view/All/job/droolsjbpm-persistence-db-single/14/ It was fixed on master branch on 2013-06-06.
This BZ has been part of the 6.0.0 stream.