So Jboss Dev has nothing to say... Any users out there have any imput?
d. -----Original Message----- From: Ferguson, Doug [mailto:[EMAIL PROTECTED]] Sent: Saturday, October 27, 2001 4:25 PM To: jBoss Dev (E-mail) Subject: RE: [JBoss-dev] Connectin Pool Problem So nobody as any idea what might be happening? We discovered that we are also seeing a XAException in or logs. Based on the JBoss code it seems that the XAException is getting throw because of a SQLException when JBoss try to call conn.commit() However JBoss swallows the SQLException so we have no idea what the underlying exception is. After more investigation we found that there seems to be a slight loop hole in the GC logic. If the CCInterval is set lower than the transactionTimeout then it is possible that the GC will return to the pool connections which are already enrolled in a transaction. This could be the reason for some of our wierd behviours, but I don't think it is the root of our problem. It just may be masking other things. Any suggestions? Avenues to explore? Thanks, d. -----Original Message----- From: Ferguson, Doug [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 24, 2001 9:51 PM To: jBoss Dev (E-mail) Subject: RE: [JBoss-dev] Connectin Pool Problem I would be into writing something for 3. However, we are going live within the next few weeks. We are in beta right now. There is no way we can switch to 3.0 With the current looming release, I haven't even had anytime to investigate the new jca configurations. It is however very important for us to figure out why our connections go south after JBoss has been running for awhile. Once we bounce JBoss everyting seems to work fine. We left JBoss running all day and we will test tomorrow. As a work around my ConnectionFactory tests all the connections we get back. It the XAClientConnection.isClosed() returns true, I keep trying to get a connection until I get a connection that is valid. I have a maxRetries set that will keep me away from an infinite loop, so if there are maxRetries worth of null connections in a row in the pool, we will be ok. However, I'd really like to understand why this is happening. d. -----Original Message----- From: David Jencks [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 24, 2001 8:25 PM To: [EMAIL PROTECTED] Subject: Re: [JBoss-dev] Connectin Pool Problem That should make very little difference. I think with XA drivers you will be relying on Oracle prepared statement caching rather than jboss ps caching. This could be faster or slower ;-) I don't suppose I could entice you into trying to set up a jboss 3 jca wrapped xa oracle ConnectionFactoryLoader configuration and contributing it to the manual? BTW I thought if anyone actually wants to use Oracle xa with jboss 3 we ought to write a special xa wrapper that also translates XIds so we don't have to force all of jboss to use Oracle XIds. Thanks David Jencks On 2001.10.24 20:25:18 -0400 "Ferguson, Doug" wrote: > How would performace differ with using OracleXid and/or > OracleXSDatasource?? > > > So I am using the XADataSourceImpl wrapper in connection pool. > > > > After jboss has been running for awhile, I start getting an exception > throw > > from the > > wrapper. After some investigation it is clear that this exception is > getting > > thrown because the internat java.sql.Connection is null. > > > > How are null connections getting into the pool? > > > > After looking through the code it seems that the only way the > connection > > can be null is through a call to the shutdown method or by calling > close. > > > > We can't figure out anymore at this time. It would be really helpfull > > if anybody has any insight. > > > > Thanks, > > > > d. > > > > _______________________________________________ > > Jboss-development mailing list > > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/jboss-development > > _______________________________________________ > Jboss-development mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-development > > _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
