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?

Answers


I've used DBCP's BasicDataSource for this. And this question has an example configuration.


Need Your Help

django import a view function

django django-views

I have a django application xxx which does a number of things.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.