title: Database connection management in Spring
body: <p>Do we have to explicitly manage database resources when using Spring Framework.. liking closing all open connections etc?</p>
  
  <p>I have read that Spring relieves developer from such boiler plate coding... </p>
  
  <p>This is to answer an error that I am getting in a Spring web app: </p>
  
  <blockquote>
    <p>org.springframework.jdbc.CannotGetJdbcConnectionException:
    Could not get JDBC Connection; nested
    exception is java.sql.SQLException:
    ORA-00020: maximum number of processes
    (150) exceeded</p>
  </blockquote>
  
  <p>The <code>jdbcTemplate</code> is configured in the xml file and the DAO implementation has reference to this <code>jdbcTemplate</code> bean which is used to query the database.</p>