We are using WebLogic EJB on my current project. We
maintain around 150 connections to the main database
(+ a whole bunch to other data sources) and this
particular aspect of the project works as advertized.
My suspicion is that the person setting up the app
server does not know how to properly configure the
connection pools as was suggested. They have a truely
ugly GUI to do this (although being an old command
line hack I prefer to just look at the config.xml
file).
When configuringn your JDBC connection pools (yeah you
can have multiple, even for the same database) you
specify such things as (this is the tuning list, not
an inclussive list):
DriverName -- we are using the oracle OCI driver so we
can use TAF and CLB
InitialCapacity -- How many connections to create when
the pool is created (defaults to 1)
MaxCapacity -- Maximum number of connections to permit
at any one time (defaults to 1)
CapacityIncrement -- Number of connections to create
at one time when there aren't enough (defaults to 1)
RefreshMinutes -- Number of minutes to wait to test
idle connections for connectivity to the database
(uses the TestTable parameter). Any connection that
fails is recreated
ShrinkingEnabled -- Permits the connection pool to be
shrunk when previously created connections are no
longer needed
ShrinkPeriodMinutes -- Period of time to wait between
checks of idle connections to shrink (assuming
ShrinkingEnabled is set)
Hope this is helpful,
Bill
- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:
> Kirti - I'm hoping you get some really good replies
> to this because it looks
> like I'll be the victim of BEA shortly. Just my
> pessimistic side. I really
> mean to say that the developers will be using
> WebLogic and I'll have to
> figure it out from the Oracle perspective.
> My guess is that WebLogic probably offers
> different options for how it
> handles connection pooling. I located the following
> document on BEA's
> website.
>
http://www.weblogic.com/docs51/classdocs/conn_pools.html
> My guess is that the default settings are being used
> and you just need to
> learn how to adjust them.
> A good JDBC reference that discusses the
> connection pooling options is
> "Java Programming with Oracle JDBC" by Donald Bales.
> It doesn't say much
> about J2EE and EJB and certainly nothing about
> WebLogic configuration, so I
> can't say whether it would apply here or not.
> Again, I hope someone that really understands
> this situation will
> respond. Maybe if they overlook your note, my
> ignorance will irritate them
> into responding.
>
> Dennis Williams
> DBA, 20% OCP
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
>
> -----Original Message-----
> Sent: Thursday, June 27, 2002 10:53 AM
> To: Multiple recipients of list ORACLE-L
>
>
> We are in the process of rolling out a Web Appl that
> uses BEA WebLogic and
> Oracle JDBC, thin driver calls to connect to
> database. These are dedicated
> connections (No MTS). The listener is overwhelmed
> with connection requests
> that at times reach 250+ per second. The 'preferred
> vendor' is blaming it on
> the limitation of the Listener, that is not capable
> of handling this load.
>
> I suspect this fine piece of software is not using
> JDBC connection pooling.
> Is there any way to find out if that's indeed the
> case? I am not involved in
> this project, and may not get access to the Appl
> Code. A co-worker is asking
> me all kinds of questions about Listener problems.
> The Vendor is suggesting
> to increase the QueueSize for the listener. They
> have already created
> multiple listeners in vain.
>
> I think the Appl code is to blame. I do not know
> much about Java/EJB etc..
> but my hunch is that this EJB container stuff does
> not smell good. For all I
> know it could be making a db connection for every
> single thing and
> disconnecting.
>
> Anyone dealt with similar issues?
> All tips are welcome and appreciated.
>
> All right, the preferred vendor is AMDOCS. Anyone
> running any of their Web
> Applications? If so, can you please contact me
> off-list?
>
> Thanks.
>
> - Kirti
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Deshpande, Kirti
> INET: kirti.deshpande_at_verizon.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Pass
INET: wbpass_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Jun 27 2002 - 17:23:27 CDT
