Oracle Mybatis insert all
<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>