I think SQL Server is creating problem only because of transaction handling, which is causing heaps of locks.
>>When you say 4-500 Entity beans... yes, they are instances of same entity bean. >>On an aside if you are using a finder to load 4-500 entities and.. I can understand that direct access through session bean might be a solution, but as per our architecture, we want only entity beans to interact with the database. -----Original Message----- From: A mailing list for Enterprise JavaBeans development [mailto:[EMAIL PROTECTED]]On Behalf Of Duncan Alexander Sent: Tuesday, February 12, 2002 10:44 PM To: [EMAIL PROTECTED] Subject: Re: Transaction related problem in Weblogic Server Ankur, It looks to me like SQL server is copping out on you here and wrapping the subsequent error in an EJBException. >>[weblogic.jdbc.mssqlserver4.TdsException: I/O exception while talking to >>the server When you say 4-500 Entity beans, is that separate instances of the same bean type? On an aside if you are using a finder to load 4-500 entities and requesting data from each of them, have you considered accessing this directly from a session layer (EJB1.1). Or using a Home method (EJB2.0)? If Im on the wrong track here then ignore those last questions. regards DGA -----Original Message----- From: A mailing list for Enterprise JavaBeans development [mailto:[EMAIL PROTECTED]] On Behalf Of Ankur Kumar Sent: 12 February 2002 01:08 To: [EMAIL PROTECTED] Subject: [EJB-INT] Transaction related problem in Weblogic Server Hi Guys, I'm using Weblogic Server 6.1 & using Session facade architecture in my project. I faced a hazardous problem, which is causing WL to shut down & so it's fatal. The problem occurs when a Session Bean (TX: RequiresNew) interacts with 400-500 Entity Beans objects (TX: Supports) to fetch some information. It might be due to incorrect handling of transactions. Here is the text, which I took out from log file: --------------- nested within: ------------------ javax.ejb.EJBException - with nested exception: [weblogic.jdbc.mssqlserver4.TdsException: I/O exception while talking to the server, java.io.IOException: Broken pipe] at com.bluefishwireless.administration.bluefishaccesspoint.AEBBluefishAcces sPoi ntBean.ejbFindAllBluefishAccessPoint(AEBBluefishAccessPointBean.java:472 ) at com.bluefishwireless.administration.bluefishaccesspoint.AEBBluefishAcces sPoi ntBean_qiw7r3_Impl.ejbFindAllBluefishAccessPoint(AEBBluefishAccessPointB ean_ qiw7r3_Impl.java:252) at java.lang.reflect.Method.invoke(Native Method) at weblogic.ejb20.manager.BeanManagedPersistenceManager.enumFinder(BeanMana gedP ersistenceManager.java:89) at weblogic.ejb20.manager.BaseEntityManager.enumFinder(BaseEntityManager.ja va:5 98) at weblogic.ejb20.internal.EntityEJBHome.finder(EntityEJBHome.java:447) at com.bluefishwireless.administration.bluefishaccesspoint.AEBBluefishAcces sPoi ntBean_qiw7r3_HomeImpl.findAllBluefishAccessPoint(AEBBluefishAccessPoint Bean _qiw7r3_HomeImpl.java:153) at com.bluefishwireless.administration.bluefishaccesspoint.AEBBluefishAcces sPoi ntBean_qiw7r3_HomeImpl_WLSkel.invoke(Unknown Source) at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:296) at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke(ReplicaAwareServerRef. java :93) at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:2 65) at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.ja va:2 2) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120) ####<Dec 4, 2001 1:54:38 PM EST> <Error> <JTA> <ham.syd.bluefishwireless.com> <myserver> <ExecuteThread: '10' for queue: 'default'> <> <188:b5b3a6967f28edb9> <000000> <Name=[EJB com.bluefishwireless.administration.bluefishaccesspoint.AEBBluefishAcces sPoi ntBean.findAllBluefishAccessPoint()],Xid=188:b5b3a6967f28edb9(2015687),S tatu s=Rolled back. [Reason=Unknown],HeuristicErrorCode=XA_HEURHAZ,numRepliesOwedMe=0,numRep lies OwedOthers=0,seconds since begin=0,seconds left=10,activeThread=Thread[ExecuteThread: '10' for queue: 'default',5,Thread Group for Queue: 'default'],ServerResourceInfo[weblogic.jdbc.jts.Connection]=(state=rolle dbac k,assigned=myserver),SCInfo[mydomain+myserver]=(state=rolledback),proper ties =({weblogic.transaction.name=[EJB com.bluefishwireless.administration.bluefishaccesspoint.AEBBluefishAcces sPoi ntBean.findAllBluefishAccessPoint()], weblogic.jdbc=t3://10.1.64.64:7001, LOCAL_ENTITY_TX=true}),OwnerTransactionManager=ServerTM[ServerCoordinato rDes criptor=(CoordinatorURL=myserver+10.1.64.64:7001+mydomain+, Resources={})],CoordinatorURL=myserver+10.1.64.64:7001+mydomain+) completed heuristically: (weblogic.jdbc.jts.Connection, HeuristicHazard, (javax.transaction.xa.XAException: I/O exception while talking to the server, java.io.EOFException)) > ####<Dec 4, 2001 1:54:38 PM EST> <Notice> <EJB> <ham.syd.bluefishwireless.com> <myserver> <ExecuteThread: '10' for queue: 'default'> <> <> <010014> <Error attempting to rollback transaction: javax.transaction.SystemException: Heuristic hazard: (weblogic.jdbc.jts.Connection, HeuristicHazard, (javax.transaction.xa.XAException: I/O exception while talking to the server, java.io.EOFException)) > javax.transaction.SystemException: Heuristic hazard: (weblogic.jdbc.jts.Connection, HeuristicHazard, (javax.transaction.xa.XAException: I/O exception while talking to the server, java.io.EOFException)) at weblogic.transaction.internal.ServerTransactionImpl.internalRollback(Ser verT ransactionImpl.java:327) at weblogic.transaction.internal.ServerTransactionImpl.rollback(ServerTrans acti onImpl.java:291) at weblogic.ejb20.internal.BaseEJBHome.handleSystemException(BaseEJBHome.ja va:2 67) at weblogic.ejb20.internal.EntityEJBHome.finder(EntityEJBHome.java:458) at com.bluefishwireless.administration.bluefishaccesspoint.AEBBluefishAcces sPoi ntBean_qiw7r3_HomeImpl.findAllBluefishAccessPoint(AEBBluefishAccessPoint Bean _qiw7r3_HomeImpl.java:153) at com.bluefishwireless.administration.bluefishaccesspoint.AEBBluefishAcces sPoi ntBean_qiw7r3_HomeImpl_WLSkel.invoke(Unknown Source) at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:296) at weblogic.rmi.cluster.ReplicaAwareServerRef.invoke(ReplicaAwareServerRef. java :93) at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:2 65) at weblogic.rmi.internal.BasicExecuteRequest.execute(BasicExecuteRequest.ja va:2 2) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120) I will really appreciate any feedback asap. Ankur Kumar Bluefish Wireless ======================================================================== === To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help". =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help". =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
