0034534: StatementFinalizer causes some overhead on each statement

    Connection con = OBDal.getInstance().getConnection();
    try {
      long i = 0L;
      while (true) {
        if (++i % 10000 == 0) {
          System.out.println(i);
        }
        PreparedStatement st = con.prepareStatement("select count(*) from ad_system");
        st.close();
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }


...
2720000
2730000
1f923ef8 77346 [http-8080-3] ERROR org.openbravo.base.exception.OBException - Exception thrown Java heap 
space
java.lang.OutOfMemoryError: Java heap space
    at java.util.Arrays.copyOf(Arrays.java:3181)
    at java.util.ArrayList.grow(ArrayList.java:261)
    at java.util.ArrayList.ensureExplicitCapacity(ArrayList.java:235)
    at java.util.ArrayList.ensureCapacityInternal(ArrayList.java:227)
    at java.util.ArrayList.add(ArrayList.java:458)
    at org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer.createStatement(StatementFinalizer.java:43)
    
at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:69)

    Connection con = OBDal.getInstance().getConnection();
    try {
      long i = 0L;
      while (i < 20000000) {
        if (++i % 10000 == 0) {
          System.out.println(i);

          // connection is returned to the pool, in this moment statements are tried
          // to be closed again and the list is cleaned up
          OBDal.getInstance().commitAndClose();
          con = OBDal.getInstance().getConnection();
        }
        PreparedStatement st = con.prepareStatement("select count(*) from ad_system");
        st.close();
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }