metsfan

I am currently making a website using java with tomcat

As anyone who has used tomcat/servlets knows, each java page gets called every time you run a new page. My problem is that i have a page which uses a database, and every time i run the page, it has to reconnect to the database. is there any way to make it so that the connection is "open", that is no matter how many times i go to this page, i never have to reconnect.

BTW, i am using postgresql and JDBC v.4

paulchwd

Well if you are using a servlet you could handle the connections in the init() method which is called only once in the servlets life (when it is first accessed) but that is not wise, it is better to do any database connections in the doPost() / doGet() methods

msi_333

I think that you have to connect to the database every time , because the "connection" object needed in every servelts page and you should close the connection to the database when u finish ur query in the page and also close the statement object ... using the close() function. I don't know why u considered it as a problem .

__________________
Don't walk in front of me, I may not follow.
Don't walk behind me, I may not lead.
Just walk beside me and be my friend