How to Pool a DataBase's Connection

[gao zhixin]

Now I have a Database Driver, and Spring distribution, and I want to know how to pool my database's connection, the DataSourceTransactionManager seems could do which, but its documentation only said "potentially allowing for one thread Connection per DataSource. "

[Masoud Kalali]

all of jdbc connection pooling frameworks are listed here
http://www.java-source.net/open-source/connection-pools
but if you want to use spring for your application base and need to use spring facilities then i suggest you look at:
myjavablog.blogspot.com/2005/06/spring-connection-pooling-with-dbcp.html
and Spring manual chapter about jdbc resources
www.springframework.org/docs/reference/jdbc.html

[Ken Krebs]

The Petclinic sample app also shows how to do it.