Hi all,
We have queries in our application that run against the Sybase IQ
database and fetch results. The queries are long running and the
transaction timeout has been set appropriately (10 minutes).
Occassionally we get this exception and the execution of the query
fails. Can anyone throw some more light on the reasons for this. We
are in production and this problem seems to occur intermittently for
the same query. I have pasted the exception stack trace below.

Thanks,
Uday



2004-01-07 11:10:48.728 Eastern Standard Time 07/01/2004 11:10:48
EST USBHGOEBOT1 GOE Count usbhgoebot1 3010019 2 Run Count DB execution
failed due to Sql Exception:JZ006: Caught IOException:
com.sybase.jdbc2.jdbc.SybConnectionDeadException: JZ0C0: Connection is
already closed.

2004-01-07 11:10:48.743 Eastern Standard Time 07/01/2004 11:10:48
EST USBHGOEBOT1 GOE Count usbhgoebot1 3010019 2 Run Count DB execution
failed due to Sql Exception:
****************** Start of Stack Trace @ Count DAO ******************
com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheck Dead(ErrorMessage.java:792)
com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3196)
com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1924)
com.sybase.jdbc2.jdbc.ResultGetter.nextResult(Resu ltGetter.java:69)
com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybS tatement.java:204)
com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybS tatement.java:187)
com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybSt atement.java:1562)
com.sybase.jdbc2.jdbc.SybStatement.executeQuery(Sy bStatement.java:1547)
com.sybase.jdbc2.jdbc.SybStatement.executeQuery(Sy bStatement.java:402)
org.jboss.resource.adapter.jdbc.WrappedStatement.e xecuteQuery(WrappedStatement.java:213)
com.dnb.goe.count.dao.CountDAO.runCount(CountDAO.j ava:3355)
com.dnb.goe.count.sb_countmgr.CountMgrBean.runCoun t(CountMgrBean.java:1069)
sun.reflect.GeneratedMethodAccessor302.invoke(Unkn own Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.jboss.ejb.StatelessSessionContainer$ContainerI nterceptor.invoke(StatelessSessionContainer.java:6 29)
org.jboss.resource.connectionmanager.CachedConnect ionInterceptor.invoke(CachedConnectionInterceptor. java:186)
org.jboss.ejb.plugins.StatelessSessionInstanceInte rceptor.invoke(StatelessSessionInstanceInterceptor .java:72)
org.jboss.ejb.plugins.AbstractTxInterceptor.invoke Next(AbstractTxInterceptor.java:84)
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTran sactions(TxInterceptorCMT.java:273)
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxIn terceptorCMT.java:104)
org.jboss.ejb.plugins.SecurityInterceptor.invoke(S ecurityInterceptor.java:117)
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInt erceptor.java:191)
org.jboss.ejb.plugins.ProxyFactoryFinderIntercepto r.invoke(ProxyFactoryFinderInterceptor.java:122)
org.jboss.ejb.StatelessSessionContainer.internalIn voke(StatelessSessionContainer.java:322)
org.jboss.ejb.Container.invoke(Container.java:674)
sun.reflect.GeneratedMethodAccessor97.invoke(Unkno wn Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.jboss.mx.capability.ReflectedMBeanDispatcher.i nvoke(ReflectedMBeanDispatcher.java:284)
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanSe rverImpl.java:549)
org.jboss.invocation.local.LocalInvoker.invoke(Loc alInvoker.java:101)
org.jboss.invocation.InvokerInterceptor.invoke(Inv okerInterceptor.java:83)
org.jboss.proxy.TransactionInterceptor.invoke(Tran sactionInterceptor.java:46)
org.jboss.proxy.SecurityInterceptor.invoke(Securit yInterceptor.java:45)
org.jboss.proxy.ejb.StatelessSessionInterceptor.in voke(StatelessSessionInterceptor.java:100)
org.jboss.proxy.ClientContainer.invoke(ClientConta iner.java:85)
$Proxy48.runCount(Unknown Source)
com.dnb.goe.count.mdb_asynchcount.AsynchCountMDB.o nMessage(AsynchCountMDB.java:180)
sun.reflect.GeneratedMethodAccessor549.invoke(Unkn own Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:324)
org.jboss.ejb.MessageDrivenContainer$ContainerInte rceptor.invoke(MessageDrivenContainer.java:434)
org.jboss.resource.connectionmanager.CachedConnect ionInterceptor.invoke(CachedConnectionInterceptor. java:186)
org.jboss.ejb.plugins.MessageDrivenInstanceInterce ptor.invoke(MessageDrivenInstanceInterceptor.java: 62)
org.jboss.ejb.plugins.AbstractTxInterceptor.invoke Next(AbstractTxInterceptor.java:84)
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTran sactions(TxInterceptorCMT.java:216)
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxIn terceptorCMT.java:104)
org.jboss.ejb.plugins.RunAsSecurityInterceptor.inv oke(RunAsSecurityInterceptor.java:90)
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInt erceptor.java:191)
org.jboss.ejb.plugins.ProxyFactoryFinderIntercepto r.invoke(ProxyFactoryFinderInterceptor.java:122)
org.jboss.ejb.MessageDrivenContainer.internalInvok e(MessageDrivenContainer.java:348)
org.jboss.ejb.Container.invoke(Container.java:674)
org.jboss.ejb.plugins.jms.JMSContainerInvoker.invo ke(JMSContainerInvoker.java:732)
org.jboss.ejb.plugins.jms.JMSContainerInvoker$Mess ageListenerImpl.onMessage(JMSContainerInvoker.java :1020)
org.jboss.jms.asf.StdServerSession.onMessage(StdSe rverSession.java:241)
org.jboss.mq.SpyMessageConsumer.sessionConsumerPro cessMessage(SpyMessageConsumer.java:636)
org.jboss.mq.SpyMessageConsumer.addMessage(SpyMess ageConsumer.java:442)
org.jboss.mq.SpySession.run(SpySession.java:294)
org.jboss.jms.asf.StdServerSession.run(StdServerSe ssion.java:177)
EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Wo rker.run(PooledExecutor.java:727)
java.lang.Thread.run(Thread.java:534)
****************** End of Stack Trace ******************