3 Replies Latest reply on Sep 28, 2004 3:48 PM by Elias Ross

    HSQL exception when sending message

    Micha³ Kochanowicz Newbie

      Hi

      Sometimes sending of message fails with SQLException shown below.

      Note that I modified DefaultDS to use such connection URL:

      jdbc:hsqldb:../server/mc/data/hypersonic/LocalDB


      due to som security advisory which recommended not allowing TCP connections.

      How can I fix this?

      java.sql.SQLException: The database is already in use by another process
       at org.hsqldb.Trace.getError(Unknown Source)
       at org.hsqldb.Trace.error(Unknown Source)
       at org.hsqldb.Log.open(Unknown Source)
       at org.hsqldb.Database$Logger.openLog(Unknown Source)
       at org.hsqldb.Database.open(Unknown Source)
       at org.hsqldb.Database.<init>(Unknown Source)
       at org.hsqldb.jdbcConnection.openStandalone(Unknown Source)
       at org.hsqldb.jdbcConnection.<init>(Unknown Source)
       at org.hsqldb.jdbcDriver.connect(Unknown Source)
       at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:147)
       at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnection(InternalManagedConnectionPool.java:352)
       at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:151)
       at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:429)
       at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:413)
       at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:331)
       at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:488)
       at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:798)
       at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)
       at org.jboss.mq.pm.jdbc2.PersistenceManager.getConnection(PersistenceManager.java:1206)
       at org.jboss.mq.pm.jdbc2.PersistenceManager.createPersistentTx(PersistenceManager.java:597)
       at org.jboss.mq.pm.TxManager.createTx(TxManager.java:79)
       at org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationManager.java:421)
       at org.jboss.mq.server.JMSServerInterceptorSupport.transact(JMSServerInterceptorSupport.java:185)
       at org.jboss.mq.server.TracingInterceptor.transact(TracingInterceptor.java:370)
       at org.jboss.mq.server.JMSServerInvoker.transact(JMSServerInvoker.java:187)
       at org.jboss.mq.il.jvm.JVMServerIL.transact(JVMServerIL.java:328)
       at org.jboss.mq.Connection.send(Connection.java:928)
       at org.jboss.mq.SpyXAResourceManager.commit(SpyXAResourceManager.java:127)
       at org.jboss.mq.SpyXAResource.commit(SpyXAResource.java:103)
       at org.jboss.tm.TransactionImpl.commitResources(TransactionImpl.java:1580)
       at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:366)
       at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:369)
       at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:253)
       at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:104)
       at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:117)
       at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
       at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
       at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:322)
       at org.jboss.ejb.Container.invoke(Container.java:674)
       at java.lang.reflect.Method.invoke(Native Method)
       at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
       at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
       at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
       at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:83)
       at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
       at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
       at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100)
       at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
       at $Proxy75.sendKodak(Unknown Source)