org.hibernate.envers.test.EnversTestingJtaBootstrap appends that
";AUTOCOMMIT=OFF"
dataSource.setUrl(configValues.get(Environment.URL).toString()
+ ";AUTOCOMMIT=OFF");
-------------------------
Best Regards,
Strong Liu <stliu at hibernate.org>
http://about.me/stliu/bio
On Mar 22, 2012, at 11:15 PM, Madhumita Sadhukhan wrote:
> 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
