tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rob S." <>
Subject Re: JDBC and Oracle
Date Thu, 01 Jan 1970 00:00:00 GMT
On Mon, 20 Aug 2001 19:52:14 +0800 wrote:
> I have a question about JDBC and Oracle.
> In my Jsp I make a connection pool bean to connect with Oracle. And I
> found when I access the Oracle it will build a new session every time.
> So at last I can't connect  with Oracle when it reaches the max session
> number. Just when I restart Tomcat the sessin disappear. But if I don't
> use the bean to connect with Oracle (direct write connection pool in the
> jsp page), I found there is no new session built. Help me!!!

This doesn't sound like a Tomcat problem.

Your bean is probably set to request scope, in which case each time a new request comes in,
it will make a new connection/session w/Oracle.

There are about a million ways to have a connection pool shared by all JSPs...

- r

View raw message