title: spring pooled connection
body: <p>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:</p>
  
  <pre><code>&lt;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}"
  /&gt;
  
  in jdbc.properties:
  jdbc.driverClassName=org.hsqldb.jdbcDriver
  </code></pre>
  
  <p>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.</p>
  
  <p>Any ideas?</p>