Re: JDBC ORACLE

From: Peter Sylvester <peters_nospam_please_at_mitre.org>
Date: Tue, 07 Jan 2003 17:40:28 -0500
Message-ID: <avfl0v$7vp$1@newslocal.mitre.org>

s Lehaire wrote:
> Hi,
> I'm under TOMCAT 3.2 + ORACLE 9i
> I've got very bad performances. So i've been said that it's due to my
> connection which are DEDICATED and not SHARED.
> So i've configure my ora TNS on myclient using toad and now they're
> connecting SHARED but my tomcat server is still connected in DEDICATED.
> I use the jdbc thin driver for connect but I don't know how to configure it
> to connect with oracle client and not directly on the oracle server.
> So how to well configure it ?
> I hope you understand my question (I'm not very good for speak-writting
> english)
>
> Thx for help
>
>

Hopefully you have some form of connection pooling, as its very expensive to open connections all the time. There is some support in Oracle's JDBC driver, or use a 3rd party pooling library.

--Peter Received on Tue Jan 07 2003 - 16:40:28 CST