How to manage db connections on server?

by

Keeping a Connection open forever is a very bad idea. It doesn’t have an endless lifetime, your application may crash whenever the DB times out the connection and closes it. Best practice is to acquire and close Connection, Statement and ResultSet in the shortest possible scope to avoid resource leaks and potential application crashes caused by the leaks and timeouts.

Since connecting the DB is an expensive task, you should consider using a connection pool to improve connecting performance. A decent applicationserver/servletcontainer usually already provides a connection pool feature in flavor of a JNDI DataSource. Consult its documentation for details how to create it. In case of for example Tomcat you can find it here.

Even when using a connection pool, you still have to write proper JDBC code: acquire and close all the resources in the shortest possible scope. The connection pool will on its turn worry about actually closing the connection or just releasing it back to pool for further reuse.

You may get some more insights out of this article how to do the JDBC basics the proper way. As a completely different alternative, learn EJB and JPA. It will abstract away all the JDBC boilerplate for you into oneliners.

Hope this helps.

See also:

More Related Contents:

  1. Is it safe to use a static java.sql.Connection instance in a multithreaded system?
  2. How to run a background task in a servlet based web application?
  3. Atomic UPDATE .. SELECT in Postgres
  4. How can I pass a reference to a stack variable to a thread?
  5. JDBC vs Web Service for Android
  6. How many threads is too many?
  7. How to create threads in nodejs
  8. If threads share the same PID, how can they be identified?
  9. how to set CPU affinity of a particular pthread?
  10. What does threadsafe mean?
  11. What resources are shared between threads?
  12. How to articulate the difference between asynchronous and parallel programming?
  13. How many memory barriers instructions does an x86 CPU have?
  14. ClassNotFoundException with PostgreSQL and JDBC
  15. Simple Thread Sample Delphi
  16. Driver JDBC PostgreSQL with Android [duplicate]
  17. To use thread in programming in vb6
  18. How would you define a pool of goroutines to be executed at once?
  19. How to share data between threads in this threaded TCPServer?
  20. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  21. How JavaFX application thread works?
  22. Is non-blocking I/O really faster than multi-threaded blocking I/O? How?
  23. Python 2.7: streaming HTTP server supporting multiple connections on one port
  24. When is a condition variable needed, isn’t a mutex enough?
  25. JavaFX working with threads and GUI
  26. Difference between user-level and kernel-supported threads?
  27. What does it mean to say Apache spawns a thread per request, but node.js does not?
  28. How to map a ResultSet with unknown amount of columns to a List and display it in a HTML table?
  29. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  30. Can we have race conditions in a single-thread program?

Leave a Comment