title: Oracle Mybatis insert all
body: <p>I am trying to do a mybatis batch insert with Oracle.
  I tried the insert all on my sql developer it works, but with Mybatis here, it complains.</p>
  
  <p>How could I fix this?</p>
  
  <pre><code>&lt;insert
          id="insertBatch"
          parameterType="java.util.List"
          keyProperty="id"
          keyColumn="COMMENT_ID"
          useGeneratedKeys="true"&gt;
          INSERT ALL
          &lt;foreach collection="list" item="comment" index="index"&gt;
          INTO COMMENT (value1, value2)
          VALUES (#{comment.value1}, #{comment.value2})
          &lt;/foreach&gt;
          SELECT *
          FROM dual
      &lt;/insert&gt;
  </code></pre>
  
  <p>And I got error like this</p>
  
  <p>org.springframework.jdbc.BadSqlGrammarException: </p>
  
  <h3>Error updating database.  Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended</h3>
  
  <h3>The error may involve xxxx-Inline</h3>
  
  <h3>The error occurred while setting parameters</h3>
  
  <blockquote>
    <h3>SQL: INSERT ALL        INTO   COMMENT (  VALUE1, VALUE2) VALUES    (    ?,    ?   )        INTO   COMMENT (  VALUE1, VALUE2  ) VALUES    (    ?,    ?    )       SELECT *   FROM dual;</h3>
  </blockquote>
  
  <h3>Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended</h3>