I have fixed some of them for oracle (Cannot execute query) in InstanceContainerTestCase with persistLocally=false. So in the next run that number should increase a little.

The other large categories failing are :
- SQLServer seems in the limbos, so nothing to look at until I see "Cannot open connection" disappear.

- Mysql X also seems weird in InstanceContainerTestCase : "An instance with id MyInstance already exist". I'll give a try to mysql.

The success rate has increased to 79.85% (1320 tests) due to the tests for oracle/InstanceContainer which are passing now.

The InstanceContainerTestCase was showing (total/errors/failures) :

84/35/1
84/33/1
84/23/1
84/23/1

84/23/1
84/23/1
84/23/1
84/23/1

I have executed the test suite against mysql5 and all tests are passing so there is something wrong in the QA mysql5 configuration which prevents tests to execute correctly.

My configuration is :

Server version: 5.0.33 Source distribution
mysql-connector-java-5.0.4-bin.jar

datasource configured in datasources.xml

<datasource>
 <datasource-name>mysql5</datasource-name>
 <connection-url>jdbc:mysql://localhost:3306/jbossportal?useServerPrepStmts=false&jdbcCompliantTruncation=false</connection-url>
 <driver-class>com.mysql.jdbc.Driver</driver-class>
 <user-name>portal</user-name>
 <password>portalpassword</password>
</datasource>

It looks like the URL is not correct for mysql :

java.lang.reflect.InvocationTargetExceptionCaused by: org.xml.sax.SAXParseException: The reference to entity "jdbcCompliantTruncation" must end with the ';' delimiter. at org.apache.xerces.parsers.DOMParser.parse(Unknown Source) at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source) at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:76) at org.jboss.portal.test.framework.embedded.DataSourceSupport$Config.fromXML(DataSourceSupport.java:271) at org.jboss.portal.test.framework.embedded.DataSourceSupport$Config.fromXML2(DataSourceSupport.java:259) at org.jboss.portal.test.cms.AbstractCMSTestCase.createTestSuite(AbstractCMSTestCase.java:83) at org.jboss.portal.test.cms.commands.TestFileArchiveUpload.suite(TestFileArchiveUpload.java:74) ... 7 more

It looks like it's improving now :

1320/7/60 with a success rate of 94.92%

I sees errors in

- CMS
- RegistrationPersistenceManagerTestCase
- WSRP (but it does not seem related to the database)

I'll look first at RegistrationPersistenceManagerTestCase.

Roy or Sohil will have to look at the CMS issues.

We'll look at WSRP later, it may be a transient issue as it was not occuring before.

I think I fixed the issues with CMS, we'll see how it goes in the next execution of the testsuite.