camunda + oracle 启动报错 解决方法

 启动报错如下:

 java.sql.SQLException: sql injection violation, comment not allow : select * from ( select a.*, ROWNUM rnum from (
    select RES.ID_,
      RES.REV_,
      RES.DUEDATE_,
      RES.PROCESS_INSTANCE_ID_,
      RES.EXCLUSIVE_
    
    from ACT_RU_JOB RES

    where (RES.RETRIES_ > 0)
      and (
       
          RES.DUEDATE_ is null or
       
          RES.DUEDATE_ <= ?
      )
      and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ < ?)
      and RES.SUSPENSION_STATE_ = 1

       

       
       

      and ( 
    ( 
    RES.EXCLUSIVE_ = 1
          and not exists(
            select J2.ID_ from ACT_RU_JOB J2
            where J2.PROCESS_INSTANCE_ID_ = RES.PROCESS_INSTANCE_ID_                                           -- from the same proc. inst.
            and (J2.EXCLUSIVE_ = 1)                                                              -- also exclusive
            and (J2.LOCK_OWNER_ is not null and J2.LOCK_EXP_TIME_ >= ?)  -- in progress
            )
   )
    or
     
    RES.EXCLUSIVE_ = 0
   
   )

       

     
      ) a where ROWNUM < ?) where rnum  >= ?

原因是 使用了druid连接池,在执行sql语句的时候 不支持注释。因为camunda的sql语句是封装在jar里,这里无法修改sql,这里添加 druid配置

      druid: 
        wall:
          comment-allow: true
 

上一篇:【服务程序的运行策略】——守护进程


下一篇:使用AT command 修改手机APN-其他AT command