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
