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 <[EMAIL PROTECTED]> 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. > [EMAIL PROTECTED] > > > > -----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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
