title: how can I batchUpdate with a query that requires 2 parameters and only one of them is stored in a list
body: <p>I use Spring-JDBC to insert the list of facebook friends for a user in my MySQL database.</p>
  
  <p>I have a final Long that contains the user uid and a List that contains the list of his friends. </p>
  
  <p>my query is:</p>
  
  <pre><code>final String sqlInsert="insert into fb_user_friends(fb_uid,friend_uid) values(?,?)";
  </code></pre>
  
  <p>I create batch parameters using SqlParameterSourceUtils</p>
  
  <pre><code>SqlParameterSource[] batch = SqlParameterSourceUtils.createBatch(friendsList.toArray());
  </code></pre>
  
  <p>and I execute the insert using:</p>
  
  <pre><code>int[] insertCounts = this._jdbcTemplate.batchUpdate(sqlInsert,batch);
  </code></pre>
  
  <p>the problem here that the list contains only the 2nd parameter that's required by the query. </p>
  
  <p>do I have to modify the friendsList to add to it another column or is there another way?</p>
  
  <p>thanks!</p>