1 Reply Latest reply on Apr 13, 2004 9:59 AM by adrian.brock

    Exception while shutting down JDBC/JCA

      hi;
      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
      edConnectionPool,name=DefaultDS
      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
      ection
      org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (ja
      va.sql.SQLException: Connection is broken: Software caused connection abort: rec
      v failed)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkExc
      eption(BaseWrapperManagedConnection.java:546)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(
      BaseWrapperManagedConnection.java:252)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.do
      Destroy(InternalManagedConnectionPool.java:502)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.fl
      ush(InternalManagedConnectionPool.java:350)

        • 1. Re: Exception while shutting down JDBC/JCA

          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.