[GitHub] [incubator-shardingsphere] strongduanmu opened a new issue #2390: shading-jdbc does not support multiline sql execution

[GitBox <gi...@apache.org>]

strongduanmu opened a new issue #2390: shading-jdbc does not support multiline sql execution
URL: https://github.com/apache/incubator-shardingsphere/issues/2390
 
 
   In my scenario, I need to update some data in a batch, which was previously able to execute multi-line sql statements at a time by mybatis foreach statements, but now that shading-jdbc is not supported, I hope to add this feature（I'm so sorry for my pool english）.
   
   Code is like this:
   ```xml
   <update id="updateDataBatch">
       <foreach collection="updateVos" item="updateVo">
           UPDATE tb_price_shard
           SET price = #{updateVo.price}
           WHERE id = #{updateVo.id};
       </foreach>
   </update>
   ```
   And error is like this:
   ```
   org.springframework.jdbc.BadSqlGrammarException: 
   ### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE tb_price_shard
   ```
   It can not parse sql and route to correct shard table.

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services