I am working on EJB 2.0 application running on Jboss server with Oracle 10g as its backend. Jboss freezes when a search functionality was invoked with certain search terms (for which records are available in the database). In Thread dump i see Jboss hangs at SocketInputStream.socketRead0. I can repeatedly see this pattern when ever i perform this search opertion. Below is the portion of Thread dump.



java.net.SocketInputStream.socketRead0(Native Method)
java.net.SocketInputStream.read(SocketInputStream. java:129)
oracle.net.ns.Packet.receive(Unknown Source)
oracle.net.ns.DataPacket.receive(Unknown Source)
oracle.net.ns.NetInputStream.getNextPacket(Unknown Source)
oracle.net.ns.NetInputStream.read(Unknown Source)
oracle.net.ns.NetInputStream.read(Unknown Source)
oracle.net.ns.NetInputStream.read(Unknown Source)
oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMA REngine.java:971)
oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMA REngine.java:941)
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 432)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4 CPreparedStatement.java:181)
oracle.jdbc.driver.T4CPreparedStatement.execute_fo r_describe(T4CPreparedStatement.java:420)
oracle.jdbc.driver.OracleStatement.execute_maybe_d escribe(OracleStatement.java:896)
oracle.jdbc.driver.T4CPreparedStatement.execute_ma ybe_describe(T4CPreparedStatement.java:452)
oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:986)
oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:2888)
oracle.jdbc.driver.OraclePreparedStatement.execute Query(OraclePreparedStatement.java:2929)
org.jboss.resource.adapter.jdbc.WrappedPreparedSta tement.executeQuery(WrappedPreparedStatement.java: 236)
org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityComma nd.execute(JDBCLoadEntityCommand.java:177)
org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityComma nd.execute(JDBCLoadEntityCommand.java:88)
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.lo adEntity(JDBCStoreManager.java:646)
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.lo adEntity(JDBCStoreManager.java:628)
org.jboss.ejb.plugins.CMPPersistenceManager.loadEn tity(CMPPersistenceManager.java:406)
org.jboss.resource.connectionmanager.CachedConnect ionInterceptor.loadEntity(CachedConnectionIntercep tor.java:252)
org.jboss.ejb.plugins.EntitySynchronizationInterce ptor.invoke(EntitySynchronizationInterceptor.java: 243)
org.jboss.resource.connectionmanager.CachedConnect ionInterceptor.invoke(CachedConnectionInterceptor. java:158)
org.jboss.ejb.plugins.EntityReentranceInterceptor. invoke(EntityReentranceInterceptor.java:126)
org.jboss.ejb.plugins.EntityInstanceInterceptor.in voke(EntityInstanceInterceptor.java:276)
org.jboss.ejb.plugins.EntityLockInterceptor.invoke (EntityLockInterceptor.java:104)
org.jboss.ejb.plugins.EntityCreationInterceptor.in voke(EntityCreationInterceptor.java:68)
org.jboss.ejb.plugins.CallValidationInterceptor.in voke(CallValidationInterceptor.java:63)
org.jboss.ejb.plugins.AbstractTxInterceptor.invoke Next(AbstractTxInterceptor.java:121)
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTran sactions(TxInterceptorCMT.java:350)
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxIn terceptorCMT.java:181)
org.jboss.ejb.plugins.SecurityInterceptor.invoke(S ecurityInterceptor.java:168)
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInt erceptor.java:205)
org.jboss.ejb.plugins.ProxyFactoryFinderIntercepto r.invoke(ProxyFactoryFinderInterceptor.java:136)
org.jboss.ejb.EntityContainer.internalInvoke(Entit yContainer.java:527)
org.jboss.ejb.Container.invoke(Container.java:954)
sun.reflect.GeneratedMethodAccessor109.invoke(Unkn own Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.jboss.mx.interceptor.ReflectedDispatcher.invok e(ReflectedDispatcher.java:155)
org.jboss.mx.server.Invocation.dispatch(Invocation .java:94)
org.jboss.mx.server.Invocation.invoke(Invocation.j ava:86)
org.jboss.mx.server.AbstractMBeanInvoker.invoke(Ab stractMBeanInvoker.java:264)
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanSe rverImpl.java:659)
org.jboss.invocation.local.LocalInvoker$MBeanServe rAction.invoke(LocalInvoker.java:169)
org.jboss.invocation.local.LocalInvoker.invoke(Loc alInvoker.java:118)
org.jboss.invocation.InvokerInterceptor.invokeLoca l(InvokerInterceptor.java:209)
org.jboss.invocation.InvokerInterceptor.invoke(Inv okerInterceptor.java:195)
org.jboss.proxy.TransactionInterceptor.invoke(Tran sactionInterceptor.java:61)
org.jboss.proxy.SecurityInterceptor.invoke(Securit yInterceptor.java:70)
org.jboss.proxy.ejb.EntityInterceptor.invoke(Entit yInterceptor.java:112)
org.jboss.proxy.ClientContainer.invoke(ClientConta iner.java:100)
$Proxy370.getValue(Unknown Source)
com.isbr.brfwk.valpha.AlphaEjbDaoImpl.getValue(Unk nown Source)
com.isbr.brfwk.valpha.AlphaEjbDaoImpl.getValue(Unk nown Source)
com.isbr.brfwk.valpha.AlphaDaoImpl.getValue(Unknow n Source)
com.isbr.brfwk.util.EntityValueList.next(Unknown Source)
com.isbr.brcos.ejb.srrequestbytrivialname.SrReques tByTrivialNameImpl.getSampleNumbers(Unknown Source)
com.isbr.brcos.ejb.srrequestbytrivialname.SrReques tByTrivialNameImpl.execute(Unknown Source)
sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.jboss.invocation.Invocation.performCall(Invoca tion.java:359)
org.jboss.ejb.StatelessSessionContainer$ContainerI nterceptor.invoke(StatelessSessionContainer.java:2 37)
org.jboss.resource.connectionmanager.CachedConnect ionInterceptor.invoke(CachedConnectionInterceptor. java:158)
org.jboss.ejb.plugins.StatelessSessionInstanceInte rceptor.invoke(StatelessSessionInstanceInterceptor .java:169)
org.jboss.ejb.plugins.CallValidationInterceptor.in voke(CallValidationInterceptor.java:63)
org.jboss.ejb.plugins.AbstractTxInterceptor.invoke Next(AbstractTxInterceptor.java:121)
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTran sactions(TxInterceptorCMT.java:350)
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxIn terceptorCMT.java:181)
org.jboss.ejb.plugins.SecurityInterceptor.invoke(S ecurityInterceptor.java:168)
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInt erceptor.java:205)
org.jboss.ejb.plugins.ProxyFactoryFinderIntercepto r.invoke(ProxyFactoryFinderInterceptor.java:136)
org.jboss.ejb.SessionContainer.internalInvoke(Sess ionContainer.java:648)
org.jboss.ejb.Container.invoke(Container.java:954)

Could any one help in figuring out this issue?

Thanks in advance
~~Krishnan