Stacktrace:
... 60 more
Caused by: java.sql.SQLException: Cannot get connection for URL
jdbc:mysql://vmg02.mw.lab.eng.bos.redhat.com:3306/dballo01;AUTOCOMMIT=OFF :
Access denied for user 'dballo01'@'%' to database 'dballo01;AUTOCOMMIT=OFF'
at
org.enhydra.jdbc.standard.StandardDataSource.getConnection(StandardDataSource.java:216)
at
org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141)
at
org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:278)
at
org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:297)
... 88 more
These tests fail in mysql51.
There are several other test failures across other databases as well but due to
hudson issues over past two days some of them have aborted abruptly.
Another common issue I see is:
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException:
[jcc][10165][10036][4.12.55] Invalid database URL syntax:
jdbc:db2://vmg06.mw.lab.eng.bos.redhat.com:50000/jbossqa;INIT=CREATE SCHEMA IF
NOT EXISTS ENVERS_AUDIT. ERRORCODE=-4461, SQLSTATE=42815
at com.ibm.db2.jcc.am.hd.a(hd.java:676)
I have started a fresh run on all databases with a patch containing fixes in
HHH-7185 after which I could investigate further.
Thanks and Regards,
Madhumita Sadhukhan
JBoss EAP QE Team
Red Hat Brno
----- Original Message -----
From: "Adam Warski" <a...@warski.org>
To: "Strong Liu" <st...@hibernate.org>
Cc: "Madhumita Sadhukhan" <msadh...@redhat.com>, "hibernate-dev@lists.jboss.org
hibernate-dev" <hibernate-dev@lists.jboss.org>
Sent: Thursday, March 22, 2012 3:48:01 PM
Subject: Re: [Hibernate-JIRA] Created: (HHH-7187) envers tests fail on other
DBs except the default H2
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)" <nore...@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: st...@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
_______________________________________________
hibernate-dev mailing list
hibernate-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev
