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