On Mon, 20 Aug 2001 19:52:14 +0800 [EMAIL PROTECTED] 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
