Need Information

[joem236]

Hi,

I am using a package which I have made containing a class to access my databases from servlets, so I don't have to keep typing in the connect, execute an get my result set code. My question for the day is, Is there a way to keep a connection open through time with a common servlet and just use that as my gateway if you will to get the data I need for other servlets?
I just need to cut down the number of times that the database is opened and closed, starting to see some weird stuff going on and I think it is because of this opening and closing.

Any help will be appreciated...

Thanks,

Joe