That's exactly what our notx cm does now, and what the local tx cm does, and what one of the settings of the xa cm does. In the jboss implementation you can also set the xa cm to delist and put connections back in the pool after each connection handle is closed. Theoretically this should result in considerably greater concurrency, and my interpretation of the xa spec is that it is required behavior for any xa resource manager/driver, but so far the only xa driver that lets you do this that I know of is the firebird driver that I wrote that goes to considerable lengths to allow this behavior.
Thanks for the info. david jencks On 2003.02.19 12:01 Rod Macpherson wrote: > Here's some blurbiage for 7.0 but it's the same thing in 6.1: > > http://www.bea.com/products/j2ee_wp_design7.shtml > > "WebLogic Server can use a single connection pool to service > multiple, > simultaneous database requests. The number and length of database > transactions that use the pool largely determine the efficiency of the > connection pool. For non-transactional database requests, WebLogic Server > can allocate and reallocate a connection very quickly, so that another > client can use the same connection. However, for transactional requests, > a > connection becomes 'reserved' by the client for the duration of the > transaction." > > For example, we had one datasource for read-only JDBC queries and another > for our EJBs and update queries. DefaultDS and DefaultDSX type thing. > > > ----- Original Message ----- > From: "David Jencks" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, February 19, 2003 8:18 AM > Subject: Re: [JBoss-user] Dynamic JCA pool size change problem > > > > On 2003.02.19 10:07 Rod Macpherson wrote: > > > Assigned an RFE to you David: > > > > Thanks. There might be enough tracking going on now so this will be > fairly > > easy to implement. > > > > > > ================================ > > > Changed the min-max settings in oracle-service.xml from 0-0 to 17-17 > and > > > database access failed: stack traces. Using the JMX console to stop, > > > change > > > and restart works fine. Using the JMX console without a stoppage > fails. > > > However, once you successfully make that change you can apply > additional > > > changes without stoppign and restarting the service. > > > ================================ > > > > > > IMO, absurd values should throw an exception or be quietly rejected: > min > > > > > > > max. If you reduce the maximum below the number of currently checked > out > > > connections that setting would ideally be deferred. BTW, in weblogic > they > > > will re-use a connection without reserving it if it's part of a > > > non-transactional pool. > > > > What exactly does this mean? Several threads get handles to the same > > physical connection at the same time? This seems like a bad idea to > me:-) > > > > thanks > > david > > > > Seems like a useful feature that JBoss could > > > adopt. > > > > > > ----- Original Message ----- > > > From: "David Jencks" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Wednesday, February 19, 2003 6:22 AM > > > Subject: Re: [JBoss-user] Dynamic JCA pool size change problem > > > > > > > > > > What happens if you stop the pool, change the limits, and start the > > > pool? > > > > You should actually stop//start the pool from > > > > ServiceController.stop(ObjectName). > > > > > > > > Can you file a rfe on this and assign it to me? I need to think > about > > > how > > > > to do these hot changes. Please describe how you would like it to > > > work, > > > > for instance what should happen if you reduce the pool size and > more > > > > connections than the new max are checked out. > > > > > > > > thanks > > > > david jencks > > > > > > > > On 2003.02.19 08:17 Rod Macpherson wrote: > > > > > Increased min-max pool connection limits from 0-10 to 17-17 on a > hot > > > > > system > > > > > and generated stack traces on database access. As you might > expect > > > > > everything was fine after bouncing JBoss. No biggie but worth > noting. > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > > > > This SF.net email is sponsored by: SlickEdit Inc. Develop an > edge. > > > > > The most comprehensive and flexible code editor you can use. > > > > > Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day > > > Trial. > > > > > www.slickedit.com/sourceforge > > > > > _______________________________________________ > > > > > JBoss-user mailing list > > > > > [EMAIL PROTECTED] > > > > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > > > > > > > > > > > > > > > > > > > ------------------------------------------------------- > > > > This SF.net email is sponsored by: SlickEdit Inc. Develop an edge. > > > > The most comprehensive and flexible code editor you can use. > > > > Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day > Trial. > > > > www.slickedit.com/sourceforge > > > > _______________________________________________ > > > > JBoss-user mailing list > > > > [EMAIL PROTECTED] > > > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > > > > > > > > > ------------------------------------------------------- > > > This SF.net email is sponsored by: SlickEdit Inc. Develop an edge. > > > The most comprehensive and flexible code editor you can use. > > > Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day > Trial. > > > www.slickedit.com/sourceforge > > > _______________________________________________ > > > JBoss-user mailing list > > > [EMAIL PROTECTED] > > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > > > > > > > > > ------------------------------------------------------- > > This SF.net email is sponsored by: SlickEdit Inc. Develop an edge. > > The most comprehensive and flexible code editor you can use. > > Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day Trial. > > www.slickedit.com/sourceforge > > _______________________________________________ > > JBoss-user mailing list > > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > ------------------------------------------------------- > This SF.net email is sponsored by: SlickEdit Inc. Develop an edge. > The most comprehensive and flexible code editor you can use. > Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day Trial. > www.slickedit.com/sourceforge > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > > ------------------------------------------------------- This SF.net email is sponsored by: SlickEdit Inc. Develop an edge. The most comprehensive and flexible code editor you can use. Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day Trial. www.slickedit.com/sourceforge _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
