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

Reply via email to