[GitHub] [incubator-shardingsphere] hebinzyz opened a new issue #2197: batch insert problem , use keyGeneratorColumnName

[GitBox]

hebinzyz opened a new issue #2197: batch insert problem , use 
keyGeneratorColumnName
URL: https://github.com/apache/incubator-shardingsphere/issues/2197
 
 
   yaml  database configure
       t_energy_heat: 
         keyGeneratorColumnName: id
         actualDataNodes: bmp.t_energy_heat
         databaseStrategy:
           none:
         tableStrategy: 
           none:
   java：
        @Insert("<script>insert into t_energy_heat 
(cid,MNum,aheat,acold,HPower,aflow,IV,IMPT,EMPT,TD,ZDFT,ZBWT,RTime,state,RT,HState)
 VALUES"
                        + "<foreach item='entity' index='index' 
collection='list' separator=','>"
                        
+"(#{entity.cid},#{entity.MNum},#{entity.aheat},#{entity.acold},#{entity.HPower},#{entity.aflow},#{entity.IV},#{entity.IMPT},#{entity.EMPT},#{entity.TD},#{entity.ZDFT},#{entity.ZBWT},#{entity.RTime},#{entity.state},#{entity.RT},#{entity.HState})"
                        + "</foreach></script>")
        int addBatchEnergyHeatData(@Param("list") List<EnergyHeatData> list);
   problem
   insert into t_energy_heat 
(cid,MNum,aheat,acold,HPower,aflow,IV,IMPT,EMPT,TD,ZDFT,ZBWT,RTime,state,RT,HState,
 id) VALUES  
    (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), ?), 
    (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), ?), 
    (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), ?),
     (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, ?) 
   
   
   

----------------------------------------------------------------
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:
us...@infra.apache.org


With regards,
Apache Git Services