title: Is it possible in ibatis to have more than one selectKey clause in the same insert query?
body: <p>I have need to populate 2 different ids in the same table on insert and I am trying to use selectKey to pull values from Oracle sequence to populate the ids.</p>
  
  <p>With one id and selectKey I have no problems but when I add the second selectKey the value does not seem to be populating (see insert stanza below).</p>
  
  <p>Is it possible to do this? Or will I need to create another query to update the second id?</p>
  
  <p>Thanks</p>
  
  <pre><code>&lt;insert id="create" parameterClass="MyObject"&gt;
  &lt;selectKey keyProperty="id" resultClass="long" type="pre"&gt;
    &lt;include refid="sequences.myObjectId" /&gt;
  &lt;/selectKey&gt;
  &lt;selectKey keyProperty="mySecondId" resultClass="long" type="pre"&gt;
    &lt;include refid="sequences.mySecondId" /&gt;
  &lt;/selectKey&gt;    
  INSERT INTO MY_OBJECT_TABLE 
  (
  MY_OBJECT_ID,
  MY_SECOND_ID,
  ...
  )
  VALUES
  )
  #id#,
  #mySecondId#,
  ...
  )
  &lt;/insert&gt;
  </code></pre>