Question
Why should we close database connections in Java?
Answers
As a best practice, we must close the resultset, the statement and the connection. If the connection is coming from a pool, on closure, the connection is sent back to the pool for reuse. We are doing this in the finally{} block, because if any exception occurs, then we still get the chance to close this.   Your Comment




  • Contributors: *,
More Software,Java Questions..
What is the inputsplit in map reduce software?
Can variables be used in Java without initialization?
What is the difference between java bean and enterprise java bean?
What is software configuration management?
How does the java database connectivity (jdbc) work?
What are the advantages of threads in java?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
What is object cloning in Java?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?


Search
Can you Answer!!
  • Q what is the Rh blood group
  • Q Home Rule League was founded by
  • Q The author of 'Advaithachintha Padhathi':
  • Q How do you set up the permitted characters?
  • Q What is the quorum of Lok sabha ?
  • Q What are the family and order of Spadefish ?
  • Q Which persons was awarded the first Rajeev Gandhi khel ratna award
  • Q What are the basic stages of a data warehouse?
  • Q What are Scaffold templates in ASP.Net MVC
  • Q Describe documentary film. Do you think that narration is useful for making a documentary films in public welfare in India.
  • Q Who became 1st Indian to score Pro-Boxing hat-trick