spring pooled connection
Could you help me to find correct datasource for my spring-mvc application. At now I use HSQLDB database and coonect to using this bean:
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource"
p:driverClassName="${jdbc.driverClassName}"
p:url="${jdbc.url}"
p:username="${jdbc.username}"
p:password="${jdbc.password}"
/>
in jdbc.properties:
jdbc.driverClassName=org.hsqldb.jdbcDriver
But I'm pretty sure, that DriverManagerDataSource don't use pooled coonection. So, it cannot be used 开发者_开发百科properly in web-applications. I tried to find other classes, but any of them in hsqldb.jar library couldn't be used as spring datasource, because they have different interfaces. I thinked to write adapter class to use it, bu I think more useful solution eists for my problem.
Any ideas?
I've used DBCP's BasicDataSource for this. And this question has an example configuration.
精彩评论