should a db connection be a singleton?

by

A DB connection should not normally be a Singleton.

Two reasons:

  1. many DB drivers are not thread safe. Using a singleton means that if you have many threads, they will all share the same connection. The singleton pattern does not give you thread saftey. It merely allows many threads to easily share a “global” instance.
  2. Personally, I think Singleton often leads to bad design: See this post (by somebody else) http://tech.puredanger.com/2007/07/03/pattern-hate-singleton/

Instead of doing this consider a database pool. The pool is shared (and could be a singleton if you wanted). When you need to do database work your code does this:

getConnectioFromPool();

doWork()
closeConnection() // releases back to pool

Sample Pool Libraries:

More Related Contents:

  1. What is an efficient way to implement a singleton pattern in Java? [closed]
  2. Singletons vs. Application Context in Android?
  3. Why is volatile used in double checked locking
  4. Implementing Singleton with an Enum (in Java)
  5. Double Checked Locking in Singleton
  6. What’s Alternative to Singleton
  7. Singleton Design Pattern: Pitfalls [closed]
  8. Why implementing a Singleton pattern in Java code is (sometimes) considered an anti-pattern in Java world?
  9. Other Ways of Singleton in Java [duplicate]
  10. Java Singleton Pattern
  11. Why use a singleton instead of static methods?
  12. When would the garbage collector erase an instance of an object that uses Singleton pattern?
  13. Singleton pattern (Bill Pugh’s solution)
  14. How to create a singleton class
  15. Design Patterns: Factory vs Factory method vs Abstract Factory
  16. Long list of if statements in Java
  17. Use Cases and Examples of GoF Decorator Pattern for IO
  18. Spring AOP vs AspectJ
  19. Builder Pattern in Effective Java
  20. Thread Safe singleton class
  21. Java double checked locking
  22. do we need volatile when implementing singleton using double-check locking
  23. Open Session In View Pattern
  24. In simplest terms, what is a factory?
  25. Why does every object in Java implicitly extend java.lang.Object class?
  26. How thread-safe is enum in java?
  27. Thread safety in Singleton
  28. When should EntityManagerFactory instance be created/opened?
  29. Why Java allows increasing the visibility of protected methods in child class?
  30. Does the Bridge Pattern decouples an abstraction from implementation?

Leave a Comment