HSQL exception when sending message
michau Sep 28, 2004 6:21 AMHi
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)