title: BasicDataSource commit not working
body: <p>I have configured the data source and set auto commit false.</p>
  
  <pre><code>&lt;bean id="dbDataSource" class="org.apache.commons.dbcp.BasicDataSource"&gt; 
          &lt;property name="driverClassName" value="${widget.database.driver}" /&gt; 
          &lt;property name="url" value="${widget.database.url}" /&gt; 
          &lt;property name="defaultAutoCommit" value="false" /&gt; 
          &lt;property name="accessToUnderlyingConnectionAllowed" value="true" /&gt;
          &lt;property name="username" value="${widget.database.username}" /&gt;
          &lt;property name="password" value="${widget.database.password}" /&gt;
          &lt;property name="maxActive" value="${widget.database.maxActive}" /&gt; 
          &lt;property name="maxIdle" value="${widget.database.maxIdle}" /&gt; 
      &lt;/bean&gt; 
  </code></pre>
  
  <p>In my DAO clas i have done it.</p>
  
  <pre><code>    public void insertDIMFactToDB(WidgetJobOutput jobOutput) throws DataAccessException {
          int rowsInserted=0;     
      try {
          logger.info("Databse insert for DIMCODE " + jobOutput.getDimCode() + " having DIMFACT value as : " + + jobOutput.getDimFact());
          jdbcTemplate = new JdbcTemplate(dataSource);
  
          Object[] params = new Object[] { 
                      jobOutput.getDimCode(), 
                      jobOutput.getDimFact()
                                  };
          rowsInserted = jdbcTemplate.update(DBConstants.INS_WIDGET_HRLY_DATA, 
                          params);
          //logger.info("Successfully inserted/updated " + rowsInserted +  " in DB");
  
      } catch (DataAccessException e) {
          throw e ;
      }
      // commit everything 
      try {
      DataSourceUtils.getConnection(jdbcTemplate.getDataSource()).commit();
          logger.info("Successfully inserted/updated " + rowsInserted +  " in DB");
      } catch (SQLException e) {
          logger.error("Error Occured while commiting data into DB:-"+ ExceptionUtils.getFullStackTrace(e));
      }
  
  
      }
  </code></pre>
  
  <p>But it is neither throwing any exception nor commiting the data. 
  Please help me to find the bug.Thanks in advance</p>