title: Using Connection Pool in JPA
body: <p>I hava a standalone JPA (Hibernate) - MySQL Application.</p>
  
  <p>My persistence.xml looks like:</p>
  
  <pre><code>     &lt;persistence-unit name="JPAProj" transaction-type="RESOURCE_LOCAL"&gt;
              &lt;!-- Persistence provider --&gt;
              &lt;provider&gt;
                  org.hibernate.ejb.HibernatePersistence
              &lt;/provider&gt;
            ....
            &lt;properties&gt;
                      &lt;property name='hibernate.show_sql' value='true'/&gt;
                      &lt;property name='hibernate.format_sql' value='true'/&gt;
                      &lt;property name='hibernate.dialect' value='org.hibernate.dialect.MySQL5InnoDBDialect'/&gt;
                      &lt;property name='hibernate.hbm2ddl.auto' value='update'/&gt;
  
                      &lt;property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver"/&gt;
                      &lt;property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost/classicmodels"/&gt;
                      &lt;property name="javax.persistence.jdbc.user" value="someuser"/&gt;
                      &lt;property name="javax.persistence.jdbc.password" value=""/&gt;
             &lt;/properties&gt;
       &lt;/persistence-unit&gt;
  </code></pre>
  
  <p><strong>I want to use a Connection Pool (say Apache DBCP) in this application, what changes do i need to make to persistence.xml?</strong>  </p>