关于mybatis的 insert into select 命令未结束问题,最后以为是sql写错了,但是,在plsql执行又没问题。最后还是解决问题,
是设置问题。
### Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束
原先的配置:
<insert id="addHistoryByPostBatchno" parameterType="paramMap" >
修改了以后,加了
useGeneratedKeys="false"
<insert id="addHistoryByPostBatchno" parameterType="paramMap" useGeneratedKeys="false" >
Insert into
Tb_Dispatch_Mail_History
(
mail_no, rec_name, rec_address, rec_telephone,
customer_no, post_opter, mail_content_name, mail_weight,
actual_postage, delivery_area, post_time, post_condition,
post_status, post_batchNo, customer_id