title: configure max pool size hikaricp hibernate JPA
body: <p>I'm trying to use hibernate jpa and hikaricp for the CP.
  But I have an issue that I dont understand, so either my config is bad ... or I do have something else.</p>
  
  <p>this is the config In have in my persistence.xml file :</p>
  
  <pre><code>&lt;properties&gt;
      &lt;!-- SQL --&gt;
          &lt;property name="hibernate.dialect" value="org.hibernate.spatial.dialect.mysql.MySQLSpatialDialect" /&gt;
          &lt;property name="hibernate.show_sql" value="false" /&gt;
          &lt;property name="hibernate.format_sql" value="false" /&gt;
          &lt;!-- HikariCP --&gt;
          &lt;property name="hibernate.connection.provider_class" value="com.zaxxer.hikari.hibernate.HikariConnectionProvider"/&gt;
          &lt;property name="hibernate.hikari.driverClassName" value="com.mysql.jdbc.Driver" /&gt;
          &lt;property name="hibernate.hikari.minimumIdle" value="5"/&gt;
          &lt;property name="hibernate.hikari.maximumPoolSize" value="30"/&gt;
          &lt;property name="hibernate.hikari.maxLifetime" value="150000"/&gt;
          &lt;property name="hibernate.hikari.dataSource.user" value="user" /&gt;
          &lt;property name="hibernate.hikari.dataSource.password" value="password" /&gt;
          &lt;property name="hibernate.hikari.jdbcUrl"
              value="jdbc:mysql://server:3306" /&gt;
      &lt;/properties&gt;
  </code></pre>
  
  <p>Still I'm having 100+ connections on the database. I thought that using maximumPoolSize it would have limit my number of connections. Is my configuration OK, based on my research it seems ok to me, but before trying to debug elsewhere I want to make sure it is.</p>
  
  <p>Thanks</p>