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) | View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3849710#3849710 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3849710 ------------------------------------------------------- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
