Hi, Jboss 2.2.2 TOMCAT Version 3.2.2 (or, at least, the name of the install directory is JBoss-2.2.2_Tomcat-3.2.2) MS Windows 2000, SP1. Relative newbie to JBoss. I've been having trouble running an app on JBoss that works fine on Sun reference. (So, I'm trying to see if it's our code that's the problem, because I've fast become aware that the Sun reference implementation lets you get away with a lot of stuff it shouldn't...) I get 'Connection is broken' errors when one of our entity beans has EJBStore invoked. The EJBStore method has previously been invoked successfully, but this is on tx.close() for the session bean that is using it. The database is the default HypersonicSQL that comes with the download. Trawling the archives gives a couple of other examples of people getting this but no two ever the same it seems, and none of them the same circs as mine. So, a couple of questions: 1. How reliable is HypersonicSQL in general? Anyone using it for real in non-trivial apps? 2. I'm considering trying with Oracle to see if I have any better luck (or at least it may allow me to point the finger of suspicion at our code). I may have some leeway as to which versions of db/drivers to install. Any advice, anyone? 3. And here's one guaranteed to start a holy war. Which is the best db to use with JBoss in terms of ease of installation and reliability once installed? (Note: performance is not my prime concern at this stage.) Thanks for any scraps you can throw me. Regards, Pat McGibbon. Trace follows: <snip> [PEejb] > 09-07-2001 14:28:43.168 BST [800] peLogger ProcessExecutorEJB:ProcessExecutor.commitTransaction() [PEejb] > 09-07-2001 14:28:43.168 BST [800] PI:34f69a:e797d92512:-7ff6@rom cgi/15.145.204.23 Process Instance:<--> ProcessInstance.ejbStore() [DefaultDS] Resource 'org.opentools.minerva.jdbc.xa.wrapper.XAResourceImpl@21c42 f' enlisted for 'org.opentools.minerva.jdbc.xa.wrapper.XAConnectionImpl@4a55f2'. [DefaultDS] Pool DefaultDS [1/1/10] gave out pooled object: org.opentools.minerv a.jdbc.xa.wrapper.XAConnectionImpl@4a55f2 [PEejb] java.rmi.ServerException: Store failed; nested exception is: [PEejb] java.sql.SQLException: Connection is broken [PEejb] java.sql.SQLException: Connection is broken [PEejb] at org.hsql.Trace.getError(Trace.java:124) [PEejb] at org.hsql.Trace.getError(Trace.java:115) [PEejb] at org.hsql.Trace.error(Trace.java:130) [PEejb] at org.hsql.jdbcConnection.executeHSQL(jdbcConnection.java:642) [PEejb] at org.hsql.jdbcConnection.execute(jdbcConnection.java:540) [PEejb] at org.hsql.jdbcStatement.fetchResult(jdbcStatement.java:499) [PEejb] at org.hsql.jdbcStatement.executeUpdate(jdbcStatement.java:52) [PEejb] at org.hsql.jdbcPreparedStatement.executeUpdate(jdbcPreparedStat ement.java:114) [PEejb] at org.opentools.minerva.jdbc.PreparedStatementInPool.executeUpd ate(PreparedStatementInPool.java:82) [PEejb] at org.jboss.ejb.plugins.jaws.jdbc.JDBCUpdateCommand.executeStat ementAndHandleResult(JDBCUpdateCommand.java:49) [PEejb] at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCC ommand.java:160) [PEejb] at org.jboss.ejb.plugins.jaws.jdbc.JDBCStoreEntityCommand.execut e(JDBCStoreEntityCommand.java:97) [PEejb] at org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.storeEntity (JAWSPersistenceManager.java:156) [PEejb] at org.jboss.ejb.plugins.CMPPersistenceManager.storeEntity(CMPPe rsistenceManager.java:401) [PEejb] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor$Instan ceSynchronization.beforeCompletion(EntitySynchronizationInterceptor.java:342) [PEejb] at org.jboss.tm.TxCapsule.doBeforeCompletion(TxCapsule.java:1228 ) [PEejb] at org.jboss.tm.TxCapsule.commit(TxCapsule.java:322) [PEejb] at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:76) [PEejb] at org.jboss.tm.TxManager.commit(TxManager.java:117) [PEejb] at org.jboss.ejb.EnterpriseContext$UserTransactionImpl.commit(En terpriseContext.java:344) [PEejb] at com.hp.hppm.procexec.ProcessExecutorEJB.commitTransaction(Pro cessExecutorEJB.java:1070) [PEejb] at com.hp.hppm.procexec.ProcessExecutorEJB.progress(ProcessExecu torEJB.java:639) [PEejb] at java.lang.reflect.Method.invoke(Native Method) [PEejb] at org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.i nvoke(StatefulSessionContainer.java:570) [PEejb] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInte rceptor.java:190) [PEejb] at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBM T.java:261) [PEejb] at org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invo ke(StatefulSessionInstanceInterceptor.java:209) [PEejb] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.ja va:195) [PEejb] at org.jboss.ejb.StatefulSessionContainer.invoke(StatefulSession Container.java:326) [PEejb] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke (JRMPContainerInvoker.java:482) [PEejb] at org.jboss.ejb.plugins.jrmp.interfaces.StatefulSessionProxy.in voke(StatefulSessionProxy.java:150) [PEejb] at $Proxy6.progress(Unknown Source) [PEejb] at com.hp.hppm.interactive.InteractiveBean.startProcess(Interact iveBean.java:318) [PEejb] at com.hp.hppm.interactive.InteractiveBean.startProcess(Interact iveBean.java:282) [PEejb] at com.hp.hppm.interactive.servlet.InteractiveServlet.startProce ss(InteractiveServlet.java:362) [PEejb] at com.hp.hppm.interactive.servlet.InteractiveServlet.processReq uest(InteractiveServlet.java:192) [PEejb] at com.hp.hppm.interactive.servlet.InteractiveServlet.doPost(Int eractiveServlet.java:160) [PEejb] at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) [PEejb] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) [PEejb] at org.apache.tomcat.core.ServletWrapper.doService(ServletWrappe r.java:405) [PEejb] at org.apache.tomcat.core.Handler.service(Handler.java:287) [PEejb] at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper. java:372) [PEejb] at org.apache.tomcat.core.ContextManager.internalService(Context Manager.java:797) [PEejb] at org.apache.tomcat.core.ContextManager.service(ContextManager. java:743) [PEejb] at org.apache.tomcat.service.http.HttpConnectionHandler.processC onnection(HttpConnectionHandler.java:213) [PEejb] at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoi nt.java:416) [PEejb] at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadP ool.java:501) [PEejb] at java.lang.Thread.run(Thread.java:484) [DefaultDS] Pool DefaultDS [0/1/10] returned object org.opentools.minerva.jdbc.x a.wrapper.XAConnectionImpl@4a55f2 to the pool. [PEejb] [PEEjb] Exception in tx.commit() javax.transaction.RollbackException: Un able to commit, tx=XidImpl [FormatId=257, GlobalId=romcgi//7, BranchQual=] statu s=STATUS_ROLLEDBACK [EmbeddedTomcatSX] [IVESRV] InteractiveServlet.processRequest: ServletException: Couldn't start process. Root cause: Exception in tx.commit(). : Unable to commit , tx=XidImpl [FormatId=257, GlobalId=romcgi//7, BranchQual=] status=STATUS_ROLLE DBACK. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user