This week's book giveaway is in the OCAJP forum.
We're giving away four copies of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) and have Khalid A Mughal & Rolf W Rasmussen on-line!
See this thread for details.
Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection Object

 
Glenny Dsilva
Ranch Hand
Posts: 42
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Connection

I am maintaining a project on servlet database is mysql.

I have a connection instance variable con.

I am using the same connection in many methods. (The code is below just typed one of the methods for explanation)

Is this the correct way to use the connection object in all the methods

or should i have seperate connections in all the methods ?

I have observed that the page does not get properly loaded if i use the instance variable con in all the methods.


But if i open and close connections in all the methods there will be lot of overhead so can anyone suggest a better way...

public class DCRDoctorData extends HttpServlet
{

Connection con;

public void doGet(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException
{
con = ConnectionHandler.getConnection(dbname);

add1();

}

private void add1()
{
Statement stmt = con.createStatement(); // using the instance variable

}
}
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You probably want to use Connection Pooling, get a connection everytime you need it and close it in finaly block when you are through using it.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic