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

[Adam Warski]

Hello,

I'd say all tests are supposed to work on all DBs, but they were written only with running on H2 in mind.
But I guess only a fraction of the failing tests actually use EnversTestingJtaBootstrap?

What are the stacktraces? And what DBs do the tests fail on?

Adam

On Mar 19, 2012, at 11:24 AM, Strong Liu wrote:

> 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
>> 
>> 
> 

-- 
Adam Warski

http://twitter.com/#!/adamwarski
http://www.softwaremill.com
http://www.warski.org