| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: WebLogic, Oracle JDBC related
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.
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).
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 - 12:28:32 CDT
 |
 |