title: Oracle - connection Pooling with spring framework
body: <p>We are trying to implement Oracle connection pooling with the help of Spring Framework. We are using DBCP connection pooling method. However the integration between DBCP and spring doesn't go down that well.</p>
  
  <p>Problem that we face is that DBCP returns PoolableConnections Object while Oracle expects OracleConnection Objects. (Throws ClassCastException)</p>
  
  <p>It seems that this problem has been handled in Oracle 11g. However I am curious as to how others have implemented Oracle connection pooling using spring framework for Oracle 10g (Using TOMCAT). </p>
  
  <p>We use Ibatis as ORM framework.</p>
  
  <p>I am sure there is a way. any help is appreciated. </p>