[jboss-dev] JBAS-4548 - Breaks the testsuite

[Adrian Brock]

Brian,

You created this test:
http://jira.jboss.com/jira/browse/JBAS-4548

org.jboss.test.deployers.ear.test.EmbeddedDatasourceUnitTestCase

The test actually passes for me, I'm assuming it should
fail with whatever problem you were seeing?
Or the problem has been fixed.

BUT....

It breaks the remaining tests, since it appears to be
shutting down hypersonic when it is undeployed:

2007-12-12 17:23:07,057 DEBUG [org.jboss.system.ServiceController]
stopping service: jboss:service=Hypersonic,database=localDB2
2007-12-12 17:23:07,057 DEBUG [org.jboss.jdbc.HypersonicDatabase]
Stopping jboss:service=Hypersonic,database=localDB2
2007-12-12 17:23:07,253 INFO  [org.jboss.jdbc.HypersonicDatabase]
Database standalone closed clean

You then get lots of errors like:

org.jboss.deployment.DeploymentException: Error while checking if table
aleady exists CTS_CMP_V1
        at
org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.tableExists(SQLUtil.java:1082)
        at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:100)
        at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:499)
        at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:396)
        at
org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:172)
...
Caused by: java.sql.SQLException: Access is denied: Session is closed
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
        at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)
        at org.hsqldb.jdbc.jdbcDatabaseMetaData.execute(Unknown Source)
        at org.hsqldb.jdbc.jdbcDatabaseMetaData.getTables(Unknown
Source)
        at
org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.tableExists(SQLUtil.java:1075)
        ... 98 more

I guess it is either using a singleton internally or getting confused
about which server should be shutdown?

I'm going to exclude the test from the testsuite run.
-- 
xxxxxxxxxxxxxxxxxxxxxxxxxxxx
Adrian Brock
Chief Scientist
JBoss, a division of Red Hat
xxxxxxxxxxxxxxxxxxxxxxxxxxxx