Spring DriverManagerDataSource vs apache BasicDataSource

java database spring apache datasource
Nazar Sobchuk picture Nazar Sobchuk · Jul 30, 2013 · Viewed 14.1k times · Source

What is the difference between Spring DriverManagerDataSource and apache BasicDataSource? Which of them is preferable and in which situations?

Thank you.

Answer

NINCOMPOOP picture NINCOMPOOP · Jul 30, 2013

As per the Spring documentation

This class is not an actual connection pool; it does not actually pool Connections. It just serves as simple replacement for a full-blown connection pool, implementing the same standard interface, but creating new Connections on every call.

If you need a "real" connection pool outside of a J2EE container, consider Apache's Jakarta Commons DBCP or C3P0. Commons DBCP's BasicDataSource and C3P0's ComboPooledDataSource are full connection pool beans, supporting the same basic properties as this class plus specific settings (such as minimal/maximal pool size etc).

Also read Controlling database connections

When using Spring's JDBC layer, you obtain a data source from JNDI or you configure your own with a connection pool implementation provided by a third party. Popular implementations are Apache Jakarta Commons DBCP and C3P0. Implementations in the Spring distribution are meant only for testing purposes and do not provide pooling.

Related questions

mybatis IllegalArgumentException: Mapped Statements collection does not contain value

i have many problem with spring e mybatis. This is my spring configuration: i have the same configuration and ComuneMapper.java and ComuneMapper.xml stay in the same folders. but i have however this error Somebody to help meeeee <?…

Read More
Does Spring's JdbcTemplate close the connection after query timeout?

I have set query timeout (getJdbcTemplate().setQueryTimeout(5)) in method with insert statement. What will happen after query timeout, does jdbc template close my connection?

Read More
Multi language database, with default fallback

I have a question that, I know, has been widely discussed about, but in my opinion, there is one aspect that still needs clarification. I am creating a web-application with a multilanguage database, I already found some good-practices articles (such …

Read More