i am using jboss 3.2.3 + hyper soniq DB. i have the hypersoniq default data source configured
every time i shut the jboss server down i get the exception below. it seems that jboss closes the database service before the JCA pool. is this the problem? what the bypass? (there were similar threads in the forum but nothing exactly like this).
here is a relevant snippet on the server.log where it seems the DB is closed before the connection pool:
16:09:58,353 INFO [HypersonicDatabase] Stopping jboss:service=Hypersonic
16:09:58,494 INFO [HypersonicDatabase] Database closed clean
16:09:58,494 INFO [JBossManagedConnectionPool] Stopping jboss.jca:service=Manag
16:09:58,510 INFO [STDOUT] Tue Apr 13 16:09:58 GMT+02:00 2004 SHUTDOWN : System
.exit() was not called
16:09:58,510 WARN [JBossManagedConnectionPool] Exception destroying ManagedConn
org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (ja
va.sql.SQLException: Connection is broken: Software caused connection abort: rec
This has been fixed in 3.2.4RC1. An extra MBean has been added which
shutdowns hsqldb and the datasource depends upon this mbean meaning
all connections are closed before hsqldb is shutdown.
I don't recommend using hsqldb for anything other testing and demos anyway.