oracle connect_by,oracle connect_by_root 这个问题请教各位大神

sql是这么写的

select id ,connect_by_root(id)   from DJGL_DJGLJ start with  PARENT_ID = ? connect by prior  id = d.PARENT_ID

错误是:

ERROR 2018/01/26 10:56:54:277  com.jfinal.core.ActionHandler.handle(ActionHandler.java:135)  /dzqt/statistics/getCurrentOrgYearReportCount com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLException: sql injection violation, syntax error: TODO : RPAREN id :

select  id,connect_by_root( id)   from DJGL_DJGLJ   start with  PARENT_ID = ? connect by prior  id =  PARENT_ID

at com.jfinal.plugin.activerecord.DbPro.find(DbPro.java:345)

at com.jfinal.plugin.activerecord.Db.find(Db.java:232)

at com.wlgj.xtjc.biz.dzqt.statistics.DzqtStatisticsService.queryYearReportCountList(DzqtStatisticsService.java:39)

at com.wlgj.xtjc.biz.dzqt.statistics.DzqtStatisticsService$$EnhancerByCGLIB$$75e49dca.CGLIB$queryYearReportCountList$2()

at com.wlgj.xtjc.biz.dzqt.statistics.DzqtStatisticsService$$EnhancerByCGLIB$$75e49dca$$FastClassByCGLIB$$436a2584.invoke()

at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)

at com.jfinal.aop.Invocation.invoke(Invocation.java:82)

at com.jfinal.aop.Callback.intercept(Callback.java:96)

at com.wlgj.xtjc.biz.dzqt.statistics.DzqtStatisticsService$$EnhancerByCGLIB$$75e49dca.queryYearReportCountList()

at com.wlgj.xtjc.biz.dzqt.statistics.DzqtStatisticsService.getJsonStr(DzqtStatisticsService.java:58)

at com.wlgj.xtjc.biz.dzqt.statistics.DzqtStatisticsService$$EnhancerByCGLIB$$75e49dca.CGLIB$getJsonStr$0()

at com.wlgj.xtjc.biz.dzqt.statistics.DzqtStatisticsService$$EnhancerByCGLIB$$75e49dca$$FastClassByCGLIB$$436a2584.invoke()

at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)

at com.jfinal.aop.Invocation.invoke(Invocation.java:82)

at com.jfinal.aop.Callback.intercept(Callback.java:96)

at com.wlgj.xtjc.biz.dzqt.statistics.DzqtStatisticsService$$EnhancerByCGLIB$$75e49dca.getJsonStr()

at com.wlgj.xtjc.biz.dzqt.statistics.DzqtStatisticsController.getCurrentOrgYearReportCount(DzqtStatisticsController.java:41)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at

这个问题怎么解决的。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值