Re: JDBC ORACLE

From: Matthias Wirtz <Matthias.Wirtz_at_epost.de>
Date: Tue, 7 Jan 2003 22:59:24 +0100
Message-ID: <avfj4l$f3oeo$1@ID-151394.news.dfncis.de>

"s Lehaire" <s.lehaire_at_meilleuregestion.com> wrote:

Hi,

> I'm under TOMCAT 3.2 + ORACLE 9i

Are you developing servlets?

> I've got very bad performances. So i've been said that it's due to my
> connection which are DEDICATED and not SHARED.

That depends on the way your are implementing the connection to the db.

#) dedicated: each servlet has his own db-connection staying alive as long as the servlet is alive

#) shared: you have a pool of connection and each servlet looks in this pool in case it needs a connection.

... and there are pertransaction and session connections.

It depends on your needs. You wrote about performence problems. Dou you have several different servlets or do you have only few servlets but tons of users accessing the servlets?

--
Matthias Wirtz  -  Karlsruhe (germany)

Received on Tue Jan 07 2003 - 15:59:24 CST