Spring JDBC connection pool best practices

by

C3PO and DBCP development have stalled mostly because they are mature. I have seen both of these drivers be able to support hundreds of transactions per second.

The Tomcat pool is a reworked & updated DBCP driver. MyBatis 3.0 also contains it’s own pooling implementation which, based on code inspection, seems solid. Finally, there’s BoneCP which claims to have the best performance. I haven’t used any of these on a project yet.

Probably the best advice is to pick any of them test it. Spring makes it easy to swap out later.

More Related Contents:

  1. Connection pooling options with JDBC: DBCP vs C3P0 [closed]
  2. DBCP – validationQuery for different Databases
  3. how to read System environment variable in Spring applicationContext
  4. Java Spring Boot: How to map my app root (“/”) to index.html?
  5. Http Post request with content type application/x-www-form-urlencoded not working in Spring
  6. Filter order in spring-boot
  7. Spring Web MVC – validate individual request params
  8. 404 error redirect in Spring with Java config
  9. JSON parameter in spring MVC controller
  10. @Valid when creating objects with jackson without controller
  11. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Software caused connection abort: recv failed [duplicate]
  12. Spring session-scoped beans (controllers) and references to services, in terms of serialization
  13. Spring RedirectAttributes: addAttribute() vs addFlashAttribute()
  14. How to do a Mongo aggregation query in Spring Data?
  15. Java Generics and Enum, loss of template parameters
  16. Hot swapping in Spring Boot
  17. Spring 3.1 Hibernate 4 exception for Inheritance [cannot be cast to org.hibernate.mapping.RootClass]
  18. Java SE + Spring Data + Hibernate
  19. Jdbctemplate query for string: EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0
  20. java.lang.IllegalArgumentException: No converter found for return value of type
  21. Spring 3.0 MVC binding Enums Case Sensitive
  22. How to return JSON data from spring Controller using @ResponseBody
  23. Spring-boot: required a bean named ‘entityManagerFactory’ that could not be found
  24. Autowired gives Null value in Custom Constraint validator
  25. Spring properties that depend on other properties
  26. Why SpringMVC Request method ‘GET’ not supported?
  27. How to tell Jackson to ignore empty object during deserialization?
  28. How to specify prefix for all controllers in Spring Boot?
  29. Array with UserType in Hibernate and PostgreSQL –> MappingException
  30. Spring Data JPA – Is it possible to sort on a calculated property?

Leave a Comment