Re: WebLogic, Oracle JDBC related

Kirti,

Taking another tack...

Why would they want to use JDBC Thin? Typically, the "thin" driver is intended for environments where the "Oracle Client" is not expected to be installed (i.e. applets on the browser) and the JDBC "OCI" driver for environments where the "Oracle Client" is expected to be installed (i.e. servlets on the app server).

JDBC Thin has some nasty quirks beyond not populating V$SESSION properly. For example, if a database object or a cursor should go invalid for any reason, a "thin" driver cannot handle the problem as an "OCI" driver can...

Just some food for thought...

-Tim

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, June 27, 2002 9:53 AM

> 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: Tim Gorman
  INET: Tim_at_SageLogix.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).