dcsimg

Is it a good idea to declare your connection object globally, open the connection in init and close it on destroy? Or is it better to just open and close it all in a doGet or doPost each time a thread request the servlet?

Alex Chaffee

Globally. Definitely. It can take upwards of 10 seconds or even several minutes to open a DB connection (depending on your sever and drivers).

See How do I access a database from my servlet or JSP?... and the topic Servlets:Databases