Bugzilla (bugzilla.redhat.com) will be under maintenance for infrastructure upgrades and will not be available on July 31st between 12:30 AM - 05:30 AM UTC. We appreciate your understanding and patience. You can follow status.redhat.com for details.
Bug 1204138 - JBoss CMP testcases fails with various databases
Summary: JBoss CMP testcases fails with various databases
Keywords:
Status: CLOSED EOL
Alias: None
Product: JBoss Enterprise Application Platform 6
Classification: JBoss
Component: Testsuite
Version: 6.4.0
Hardware: Unspecified
OS: Unspecified
unspecified
low
Target Milestone: ---
: ---
Assignee: Jason T. Greene
QA Contact: Marek Kopecky
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2015-03-20 13:10 UTC by Marek Kopecky
Modified: 2019-08-19 12:45 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2019-08-19 12:45:08 UTC
Type: Bug


Attachments (Terms of Use)
Jenkins error logs (2.04 MB, application/zip)
2015-03-20 13:15 UTC, Marek Kopecky
no flags Details

Description Marek Kopecky 2015-03-20 13:10:51 UTC
Description of problem:
    Many JBoss CMP testcases from testsuite pass for H2 database, but not for other certified databases. Testcases expect h2 database.

Testcases fail with these databases:
    Enterprise DB Postgres Plus Advanced Server 9.2
    Enterprise DB Postgres Plus Advanced Server 9.3 (9.3.1.3)
    IBM DB2 Enterprise e10.1 (FP4 10.1.0.4)
    IBM DB2 Enterprise e10.5 (FP3 10.5.0.3)
    IBM DB2 Enterprise e9.7 (FP9 9.7.0.9)
    Microsoft SQL Server 2008 R2 SP2
    Microsoft SQL Server 2012 SP2
    Microsoft SQL Server 2014
    MySQL 5.5 (5.5.39)
    MySQL 5.7 (5.7.4)
    Oracle 11g R1 (11.1.0.7.0)
    Oracle 11g R1 RAC (11.1.0.7.0)
    Oracle 11g R2 (11.2.0.4.0)
    Oracle 11g R2 RAC (11.2.0.4.0)
    Oracle 12c (12.1.0.2.0)
    PostgreSQL 9.2 (9.2.9)
    PostgreSQL 9.3 (9.3.1)
    Sybase ASE 15.7 (SP130)

Affected testcases or tests:
org.jboss.as.test.integration.ejb.entity.cmp.callback.CheckCacheAfterRemoveDifferentTxUnitTestCase 
org.jboss.as.test.integration.ejb.entity.cmp.callback.CheckCallEjbStoreOnCleanUnitTestCase
org.jboss.as.test.integration.ejb.entity.cmp.callback.CheckEjbStoreDifferentTxUnitTestCase
org.jboss.as.test.integration.ejb.entity.cmp.callback.CheckSameTxUnitTestCase
org.jboss.as.test.integration.ejb.entity.cmp.cascadedelete.CascadeDeleteUnitTestCase
org.jboss.as.test.integration.ejb.entity.cmp.commerce.CommerceCascadeDeleteTestCase
org.jboss.as.test.integration.ejb.entity.cmp.commerce.CommerceCascadeDeleteTestCase.testCascadeDelete 
org.jboss.as.test.integration.ejb.entity.cmp.commerce.CommerceTestCase
org.jboss.as.test.integration.ejb.entity.cmp.commerce.CommerceTestCase.testCMRReset 
org.jboss.as.test.integration.ejb.entity.cmp.commerce.CommerceTestCase.testCMRSetFromNewCollection 
org.jboss.as.test.integration.ejb.entity.cmp.commerce.CommerceTestCase.test_dvo 
org.jboss.as.test.integration.ejb.entity.cmp.commerce.CommerceTestCase.test_findDoubleJoin 
org.jboss.as.test.integration.ejb.entity.cmp.commerce.CommerceTestCase.testIsIdentical 
org.jboss.as.test.integration.ejb.entity.cmp.commerce.CommerceTestCase.test_setInPostCreate 
org.jboss.as.test.integration.ejb.entity.cmp.commerce.LazyResultSetLoadingTestCase
org.jboss.as.test.integration.ejb.entity.cmp.commerce.LazyResultSetLoadingTestCase.testLazyResultSetLoading 
org.jboss.as.test.integration.ejb.entity.cmp.commerce.ManyToManyBiTestCase
org.jboss.as.test.integration.ejb.entity.cmp.commerce.ManyToOneUniTestCase
org.jboss.as.test.integration.ejb.entity.cmp.commerce.ManyToOneUniTestCase.test_b1jSetA_b2kGetA 
org.jboss.as.test.integration.ejb.entity.cmp.commerce.OneToManyBiTestCase
org.jboss.as.test.integration.ejb.entity.cmp.commerce.OneToManyBiTestCase.test_a1GetB_addB2m 
org.jboss.as.test.integration.ejb.entity.cmp.commerce.OneToManyBiTestCase.test_a1GetB_removeB1n 
org.jboss.as.test.integration.ejb.entity.cmp.commerce.OneToManyBiTestCase.test_a1SetB_a2GetB 
org.jboss.as.test.integration.ejb.entity.cmp.commerce.OneToManyBiTestCase.test_b2mSetA_b1nGetA 
org.jboss.as.test.integration.ejb.entity.cmp.commerce.OneToOneUnitTestCase
org.jboss.as.test.integration.ejb.entity.cmp.commerce.OrderByQueryTestCase
org.jboss.as.test.integration.ejb.entity.cmp.commerce.TxTesterTestCase 
org.jboss.as.test.integration.ejb.entity.cmp.commerce.TxTesterTestCase.testTxTester_none 
org.jboss.as.test.integration.ejb.entity.cmp.commerce.UserLocalTestCase
org.jboss.as.test.integration.ejb.entity.cmp.commerce.UserLocalTestCase.testDeclaredSql 
org.jboss.as.test.integration.ejb.entity.cmp.optimisticlock.OptimisticLockUnitTestCase
org.jboss.as.test.integration.ejb.entity.cmp.optimisticlock.OptimisticLockUnitTestCase.testTimestampStrategyFail 
org.jboss.as.test.integration.ejb.entity.cmp.postcreate.PostCreateTestCase
org.jboss.as.test.integration.ejb.entity.cmp.readonly.ReadOnlyCMPUnitTestCase
org.jboss.as.test.integration.ejb.entity.cmp.readonly.ReadOnlyFieldCMPUnitTestCase
org.jboss.as.test.integration.ejb.entity.cmp.relationship.manyToManyBidirectional.CmpRelMTMBTestCase
org.jboss.as.test.integration.ejb.entity.cmp.relationship.oneToOneBidirectionalWithTableMapping.ChildParentTestCase
org.jboss.as.test.integration.ejb.entity.cmp.simple.SimpleCMPUnitTestCase
org.jboss.as.test.integration.ejb.entity.cmp.splitjars.SplitJarCmpTestCase
org.jboss.as.test.integration.ejb.entity.cmp.splitjars.SplitJarCmpTestCase.testBooleanPrimitive 
org.jboss.as.test.integration.ejb.remote.entity.cmp.commerce.CascadeDeleteTestCase
org.jboss.as.test.integration.ejb.remote.entity.cmp.commerce.CascadeDeleteTestCase.testCascadeDelete 
org.jboss.as.test.integration.ejb.remote.entity.cmp.commerce.CommerceTestCase.test_dvo 
org.jboss.as.test.integration.ejb.remote.entity.cmp.commerce.CommerceTestCase.test_findDoubleJoin 
org.jboss.as.test.integration.ejb.remote.entity.cmp.commerce.CommerceTestCase.test_getOrdersShippedToCA 
org.jboss.as.test.integration.ejb.remote.entity.cmp.commerce.CommerceTestCase.test_getStatesShipedTo 
org.jboss.as.test.integration.ejb.remote.entity.cmp.commerce.CommerceTestCase.testIsIdentical 
org.jboss.as.test.integration.ejb.remote.entity.cmp.commerce.CommerceTestCase.test_setInPostCreate 
org.jboss.as.test.integration.ejb.remote.entity.cmp.commerce.LazyResultSetLoadingTestCase
org.jboss.as.test.integration.ejb.remote.entity.cmp.commerce.LazyResultSetLoadingTestCase.testLazyResultSetLoading 
org.jboss.as.test.integration.ejb.remote.entity.cmp.commerce.UserTestCase.testDeclaredSql 

Version-Release number of selected component (if applicable):
    6.4.0.CR1

How reproducible:
    Always

Steps to Reproduce:
1. Replace datasource definition in all server config files (especially standalone.xml), example of new datasource:
    <datasource jta="true" jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">
        <connection-url>jdbc:mysql://db01.mw.lab.eng.bos.redhat.com:3306/dballo11</connection-url>
        <driver>mysql-connector-java-5.1.33-bin.jar</driver>
        <security>
            <user-name>dballo11</user-name>
            <password>dballo11</password>
        </security>
    </datasource>
2. Copy JDBC driver to deploy folders (example: $JBOSS_DIS/standalone/deployments)
3. Run testsuite:
     ./integration-tests.sh -Dmaven.repo.local=$MAVEN_REPO_LOCAL -fae -Dmaven.test.failure.ignore=true -Dnode0=$MYTESTIP_1 -Dnode1=$MYTESTIP_2 -DallTests -Djboss.dist=$JBOSS_DIST
   or only one affected testcase:
     ./integration-tests.sh -Dmaven.repo.local=$MAVEN_REPO_LOCAL -fae -Dmaven.test.failure.ignore=true -Dnode0=$MYTESTIP_1 -Dnode1=$MYTESTIP_2 -Djboss.dist=$JBOSS_DIST -Dts.basic -Dtest=OptimisticLockUnitTestCase

Actual results:
    Failures in test case.

Expected results:
    No failures in test case.

Additional info:
    Jenkins logs:
        https://jenkins.mw.lab.eng.bos.redhat.com/hudson/job/eap-6x-as-testsuite-rhel-database/30/testReport

Comment 1 Marek Kopecky 2015-03-20 13:15:01 UTC
Created attachment 1004483 [details]
Jenkins error logs


Note You need to log in before you can comment on or make changes to this bug.