title: How to execute a JPA Bulk Update statement which takes a List as a parameter value
body: <p>I have an Update Query that looks like this</p>
  <pre><code>UPDATE 
      table_name 
  SET 
      column_name = ? 
  WHERE
      column_name = ? AND id in (?)
  </code></pre>
  <p>So the JPA transaction is</p>
  <pre><code>em.createNativeQuery(Update_QUERY)
     .setParameter(1, updatedStatus)
     .setParameter(2, currentStatus)
     .setParameter(3, ids)
     .executeUpdate();
  </code></pre>
  <p>The Input to the method is List id, currentStatus, and updatedStatus</p>
  <p>How do I pass the List as a single parameter, if I convert the List to a comma-separated String I get the error Specified text is not number as strings is not allowed in the In clause.</p>