level 7
小楼151
楼主
org.springframework.jdbc.BadSqlGrammarException:
### Error updating database. Cause: java.sql.SQLException: ORA-00933: SQL 命令未正确结束
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: insert into t_fwaq_jcgl_jcglb(drpc,ssfgs,sscd,xlmc,xlid,pzh,clid,jcrq,jcsj,qzz,czry,cjr,cjsj,sjly,xxzt,flag,bz,nodeid) select temp.drpc,tcl.fgsid, tcl.cdid, temp.xlmc,tcl.xlid,tcl.c
lz
bh,tcl.ckclid,temp.jcrq,temp.jcsj,temp.qzz,temp.czry,'727A73A5-6769-4436-B3AE-EC507973DE1D' cjr, to_char(sysdate,'yyyy-MM-dd HH:mm:ss') cjsj,'fgs' sjly,'00' xxzt,temp.flag,temp.bz,'flowchartWindow1' nodeid from t_fwaq_jcgl_jcdrglb_temp temp left join t_jc_cl_view tcl on tcl.clzbh=temp.pzh and tcl.clzt='10' and tcl.clyt='210' where temp.drpc=2 and length(temp.xlmc)>0
### Cause: java.sql.SQLException: ORA-00933: SQL 命令未正确结束
; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-00933: SQL 命令未正确结束
2016年08月01日 04点08分
1
### Error updating database. Cause: java.sql.SQLException: ORA-00933: SQL 命令未正确结束
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: insert into t_fwaq_jcgl_jcglb(drpc,ssfgs,sscd,xlmc,xlid,pzh,clid,jcrq,jcsj,qzz,czry,cjr,cjsj,sjly,xxzt,flag,bz,nodeid) select temp.drpc,tcl.fgsid, tcl.cdid, temp.xlmc,tcl.xlid,tcl.c
lz
bh,tcl.ckclid,temp.jcrq,temp.jcsj,temp.qzz,temp.czry,'727A73A5-6769-4436-B3AE-EC507973DE1D' cjr, to_char(sysdate,'yyyy-MM-dd HH:mm:ss') cjsj,'fgs' sjly,'00' xxzt,temp.flag,temp.bz,'flowchartWindow1' nodeid from t_fwaq_jcgl_jcdrglb_temp temp left join t_jc_cl_view tcl on tcl.clzbh=temp.pzh and tcl.clzt='10' and tcl.clyt='210' where temp.drpc=2 and length(temp.xlmc)>0
### Cause: java.sql.SQLException: ORA-00933: SQL 命令未正确结束
; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-00933: SQL 命令未正确结束