How to completely disable JDBC Connection Pooling in Spring / Tomcat?

Question

I'm using a Spring Data Source bean to configure a JDBC connection.

What's the easiest way to have this return a bare, unpooled / unmanaged JDBC connection?

Answer 1

I think you are looking for org.springframework.jdbc.datasource.SimpleDriverDataSource this class is a very simple implementation of javax.sql.DataSource and doesn't implement connection pooling, instead it always returns a new connection.

You can find source code here