title: Maximum size for query collection parameter in JPA 2.1 / EclipseLink 2.5.2
body: <p>Is there a maximum size for a query collection parameter in JPA 2.1 / EclipseLink 2.5.2 (connecting to mysql 5.6, if that matters)?</p>
  
  <p>e.g., what is the maximum allowable and/or recommend size for <code>ids</code> in the following code, to ensure performance and to avoid any possible bugs or issues in JPA / EclipseLink / mysql?:</p>
  
  <pre><code>@PersistenceContext
  private EntityManager em;
  
  {
      final Collection&lt;Long&gt; ids = /*obtain a Collection of IDs*/;
  
      em.createQuery("select e from Entity1 e where e.id in :ids")
          .setParameter("ids", ids);
  }
  </code></pre>