[
http://jira.jboss.com/jira/browse/JBAS-4152?page=comments#action_12375989 ]
Heiko W. Rupp commented on JBAS-4152:
-------------------------------------
Ok, it looks like the previous "system" index name started with PK_IDX,
while system generated indexes now start with "SYS_IDX" (this is a printout of
all found indexes in that test:
14:17:24,169 INFO [STDOUT] Running the test ..
14:17:24,170 INFO [STDOUT] -- SYS_IDX_69
14:17:24,170 INFO [STDOUT] -- SYS_IDX_69
14:17:24,170 INFO [STDOUT] -- B_IDX5
14:17:24,170 INFO [STDOUT] -- IDX_CMR2_REL_IDX3
14:17:24,170 INFO [STDOUT] - done ---
When I add SYS_IDX to the check in lookForIndexOnTable():
// Ignore indices that are autogenerated for PKs
if (cName.equals(column) && !iName.startsWith("PK_IDX")
&& !iName.startsWith("SYS_IDX"))
then all tests pass for me.
I think it is valid to modify the testsuite accordingly.
Upgrade to hsql 1.8.0.7 causes
org.jboss.test.cmp2.idxandusersql.test.IdxAndUsersqlUnitTestCase::testCMRmn2 to fail
-------------------------------------------------------------------------------------------------------------------
Key: JBAS-4152
URL:
http://jira.jboss.com/jira/browse/JBAS-4152
Project: JBoss Application Server
Issue Type: Sub-task
Security Level: Public(Everyone can see)
Components: EJB2
Environment: BEA JRockit 1.5.0_08 on Red Hat Enterprise Linux AS release 4
(Nahant Update 4)
Reporter: Vivek Lakshmanan
Assigned To: Heiko W. Rupp
Fix For: JBossAS-4.2.2.GA
On upgrade of HSQLDB from 1.8.0.2 to 1.8.0.7 the following testcase seems to consistently
fail:
org.jboss.test.cmp2.idxandusersql.test.IdxAndUsersqlUnitTestCase::testCMRmn2
Error: FKey cmr2_id is indexed
The test reports say:
junit.framework.AssertionFailedError: Error: FKey cmr2_id is indexed
at
org.jboss.test.cmp2.idxandusersql.test.IdxAndUsersqlUnitTestCase.testCMRmn2(IdxAndUsersqlUnitTestCase.java:190)
at net.sourceforge.junitejb.EJBTestCase.runBare(EJBTestCase.java:133)
at net.sourceforge.junitejb.EJBTestRunnerBean.runTestCase(EJBTestRunnerBean.java:102)
at net.sourceforge.junitejb.EJBTestRunnerBean.run(EJBTestRunnerBean.java:44)
at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
at
org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
at
org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:173)
at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:77)
at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
at
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:136)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
The sourcefile for the test says:
/*
* Look for indices on the m:n mapping table
* This is for hsql a strange case, at indices are put there
* anyway, but it has been told that other databases don't do
* it by themselves, so we check if the creation succeeds.
*/
Would like to get an experts opinion on it
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira