[hibernate-dev] Fwd: [Hibernate-JIRA] Created: (HHH-7187) envers tests fail on other DBs except the default H2

[Strong Liu]

Hi Adam,

any comments?
-------------------------
Best Regards,

Strong Liu <stliu at hibernate.org>
http://about.me/stliu/bio

Begin forwarded message:

> From: "Strong Liu (JIRA)" <noreply at atlassian.com>
> Subject: [Hibernate-JIRA] Created: (HHH-7187) envers tests fail on other DBs except the default H2
> Date: March 20, 2012 2:23:50 AM GMT+08:00
> To: stliu at hibernate.org
> 
> envers tests fail on other DBs except the default H2
> ----------------------------------------------------
> 
>                 Key: HHH-7187
>                 URL: https://hibernate.onjira.com/browse/HHH-7187
>             Project: Hibernate ORM
>          Issue Type: Bug
>          Components: envers
>            Reporter: Strong Liu
>             Fix For: 4.1.2
> 
> 
> due to the change of HHH-7185, there are some failing tests:
> 
> {quote}
> All Failed Tests
> 
> Test Name   
> Duration   
> Age   
>>>> org.hibernate.envers.test.integration.jta.JtaExceptionListener.testTransactionRollback[0] 	0.016	1
>>>> org.hibernate.envers.test.integration.jta.JtaExceptionListener.testDataNotPersisted[0] 	0.084	1
>>>> org.hibernate.envers.test.integration.jta.JtaExceptionListener.testTransactionRollback[1] 	0.01	1
>>>> org.hibernate.envers.test.integration.jta.JtaExceptionListener.testDataNotPersisted[1] 	0.013	1
>>>> org.hibernate.envers.test.integration.manytomany.unidirectional.M2MIndexedListNotAuditedTarget.initData[0] 	0.097	1
>>>> org.hibernate.envers.test.integration.manytomany.unidirectional.M2MIndexedListNotAuditedTarget.testHistory1[0] 	0.0050	1
>>>> org.hibernate.envers.test.integration.manytomany.unidirectional.M2MIndexedListNotAuditedTarget.testHistory2[0] 	0.0010	1
>>>> org.hibernate.envers.test.integration.manytomany.unidirectional.M2MIndexedListNotAuditedTarget.testRevisionsCounts[0] 	0.0020	1
>>>> org.hibernate.envers.test.integration.manytomany.unidirectional.M2MIndexedListNotAuditedTarget.initData[1] 	0.115	1
>>>> org.hibernate.envers.test.integration.manytomany.unidirectional.M2MIndexedListNotAuditedTarget.testHistory1[1] 	0.0010	1
>>>> org.hibernate.envers.test.integration.manytomany.unidirectional.M2MIndexedListNotAuditedTarget.testHistory2[1] 	0.0010	1
>>>> org.hibernate.envers.test.integration.manytomany.unidirectional.M2MIndexedListNotAuditedTarget.testRevisionsCounts[1] 	0.0	1
>>>> org.hibernate.envers.test.integration.naming.BasicNaming.testHistoryOfId1[0] 	0.048	1
>>>> org.hibernate.envers.test.integration.naming.BasicNaming.testHistoryOfId2[0] 	0.029	1
>>>> org.hibernate.envers.test.integration.naming.BasicNaming.testRevisionsCounts[0] 	0.016	1
>>>> org.hibernate.envers.test.integration.naming.BasicNaming.testHistoryOfId1[1] 	0.041	1
>>>> org.hibernate.envers.test.integration.naming.BasicNaming.testHistoryOfId2[1] 	0.025	1
>>>> org.hibernate.envers.test.integration.naming.BasicNaming.testRevisionsCounts[1] 	0.03	1
>>>> org.hibernate.envers.test.integration.naming.EstonianTableAlias.testAuditChildTableAlias[0] 	0.033	1
>>>> org.hibernate.envers.test.integration.naming.EstonianTableAlias.testAuditChildTableAlias[1] 	0.044	1
>>>> org.hibernate.envers.test.integration.naming.VersionsJoinTableNaming.testHistoryOfUniId1[0] 	0.108	1
>>>> org.hibernate.envers.test.integration.naming.VersionsJoinTableNaming.testRevisionsCounts[0] 	0.031	1
>>>> org.hibernate.envers.test.integration.readwriteexpression.ReadWriteExpressionChange.shouldRespectWriteExpression[0] 	0.0030	1
>>>> org.hibernate.envers.test.integration.readwriteexpression.ReadWriteExpressionChange.shouldRespectWriteExpression[1] 	0.0040	1
>>>> org.hibernate.envers.test.integration.reventity.CustomDate.testDatesForRevisions[0] 	0.0090	1
>>>> org.hibernate.envers.test.integration.reventity.CustomDate.testFindRevision[0] 	0.0050	1
>>>> org.hibernate.envers.test.integration.reventity.CustomDate.testRevisionsForDates[0] 	0.012	1
>>>> org.hibernate.envers.test.integration.reventity.CustomDate.testTimestamps[0] 	0.0030	1
>>>> org.hibernate.envers.test.integration.reventity.CustomDate.testTimestamps1[0] 	0.0040	1
>>>> org.hibernate.envers.test.integration.reventity.CustomDate.testDatesForRevisions[1] 	0.0070	1
>>>> org.hibernate.envers.test.integration.reventity.CustomDate.testFindRevision[1] 	0.0040	1
>>>> org.hibernate.envers.test.integration.reventity.CustomDate.testRevisionsForDates[1] 	0.027	1
>>>> org.hibernate.envers.test.integration.reventity.CustomDate.testTimestamps[1] 	0.014	1
>>>> org.hibernate.envers.test.integration.reventity.CustomDate.testTimestamps1[1] 	0.015	1
>>>> org.hibernate.envers.test.integration.reventity.DifferentDBSchemaTest.initData[0] 	0.0090	1
>>>> org.hibernate.envers.test.integration.reventity.DifferentDBSchemaTest.testHistoryOfId1[0] 	0.0010	1
>>>> org.hibernate.envers.test.integration.reventity.DifferentDBSchemaTest.testRevisionsCounts[0] 	0.0	1
>>>> org.hibernate.envers.test.integration.reventity.DifferentDBSchemaTest.initData[1] 	0.0060	1
>>>> org.hibernate.envers.test.integration.reventity.DifferentDBSchemaTest.testHistoryOfId1[1] 	0.0090	1
>>>> org.hibernate.envers.test.integration.reventity.DifferentDBSchemaTest.testRevisionsCounts[1] 	0.0	1
>>>> org.hibernate.envers.test.integration.strategy.ValidityAuditStrategyRevEndTsTest.testAllRevEndTimeStamps[0] 	0.145	1
>>>> org.hibernate.envers.test.integration.strategy.ValidityAuditStrategyRevEndTsTest.testAllRevEndTimeStamps[1] 	0.173	1
> {quote}
> 
> this is caused by the _org.hibernate.envers.test.EnversTestingJtaBootstrap#updateConfigAndCreateTM_, this class updates the db connection url and appends a `;AUTOCOMMIT=OFF`, but this property is only valid on H2
> 
> do tests using _org.hibernate.envers.test.EnversTestingJtaBootstrap_ are supposed only running on H2?
> if so, we need move those tests into _src/test/main_
> 
> or we need to fix these tests
> 
> --
> This message is automatically generated by JIRA.
> For more information on JIRA, see: http://www.atlassian.com/software/jira
> 
>