();
}
catch( SQLException sqlEx )
{
System.out.println( "Problem occurs
while closing " + sqlEx );
}
conn = null;
}
}
}
}
-Caroline
--- Michael Ni <[EMAIL PROTECTED]> wrote:
> thx car
Did you configure a connection pool in Tomcat? Then,
get a connection object from the pool for each data
search method invocation.
I am at work now. I do not have the configuration
with me. I can post the configuration and the
database access code when I get home.
Meanwhile, do a search on the
Hi, you should definitely close the connection right
after the method that is invoked. The connection
should be closed in the 'finally' block.
May we know the reason why you think the closing would
defeat the purpose of connection pooling?
--- Khawaja Shams <[EMAIL PROTECTED]> wrote:
> Hello,
>
