Connection

Hi,
    In one of the functions in my servlet a connection is opened thru JDBC.
In the try - catch - finally block of the code the connection is closed.

I know that to open and close connections  in not the correct way to do it.

After sometime the database shows maximum sessions exceeded and locks up.
Could this be becoz of this reason or someother reason.

I also wanted a design stratergy to open database connections in a servlet.

Maybe define a global static connection object and open it in init() and
close it when the servelet is unloaded in destroy().

any better ideas?

TIA,
uthiresh

___________________________________________________________________________
To unsubscribe, send email to [email protected] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html