@wenshao 你好~
点击SQL List 其中一个 报错 ,请问怎么处理 谢谢~
com.alibaba.druid.sql.parser.SQLParseException: syntax error, expect RPAREN, actual ORDER order com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:121) com.alibaba.druid.sql.dialect.oracle.parser.OracleSelectParser.select(OracleSelectParser.java:102) com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser.parseStatementList(OracleStatementParser.java:197) com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser.parseStatementList(OracleStatementParser.java:134) com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:68) com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:223) com.alibaba.druid.stat.DruidStatService.getSqlStat(DruidStatService.java:271) com.alibaba.druid.stat.DruidStatService.service(DruidStatService.java:126) com.alibaba.druid.support.http.StatViewServlet.service(StatViewServlet.java:245) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:94)
我测试了,0.2.11也存在此问题,问题已经修正,将会在下个版本中发布解决,下个版本大约在下周发布。非常感谢!<aclass='referer'target='_blank'>@红薯 帮忙看一下~谢谢挺急的~<imgsrc="http://www.oschina.net/js/ke/plugins/emoticons/images/1.gif"alt=""/>回复<aclass='referer'target='_blank'>@红薯:哦~谢谢新年快乐~我没用过它的监控功能,现在放假期间,耐心等待
请提供以下信息:
1)druid版本号
2)产生错误的SQL
3)数据库类型,比如说是mysql/oracle/postgres等
<aclass='referer'target='_blank'>@wenshaodruid版本号0.2.6,数据库类型:oracle11g,产生错误的SQL:WITHaAS(SELECTTO_CHAR(csl.create_time,'yyyyMMdd')create_time,cwl.client_keyck,csl.src_idsrc_idFROMxxxxcsl,xxxxcwlWHERE1=1ANDcsl.src_id=cwl.src_idANDcsl.curr_url=cwl.curr_urlANDTO_CHAR(csl.create_time,'yyyyMMdd')BETWEEN?AND?ANDcwl.day=TO_CHAR(csl.create_time,'yyyyMMdd')GROUPBYcwl.client_key,csl.src_id,csl.create_timeORDERBYcsl.src_id),bAS(SELECTitn.buyerpaytime,itn.esc_orderid,itn.oldck,MAX(con.PAYED_AMOUNT)gmv,MAX(con.buyer_onlyid)buyerFROMxxxxitn,xxxxdon,xxxxconWHEREdon.esc_orderid=itn.esc_orderidANDcon.esc_orderid=itn.esc_orderidANDdon.order_statusIN(4,5,6,7,8)ANDitn.buyerpaytimeBETWEEN?AND?GROUPBYitn.esc_orderid,itn.oldck,itn.buyerpaytime)SELECTMAX(cos.location)ASposition,a.src_idASsrcid,COUNT(DISTINCTb.esc_orderid)ASorders,SUM(b.gmv)ASuvGmv,COUNT(DISTINCTbuyer)ASbuyersFROMa,b,cp_operate_statisticscosWHEREa.ck=b.oldck(+)ANDTO_CHAR(cos.day,'yyyyMMdd')=a.create_timeANDa.create_time=b.buyerpaytimeANDa.src_id=cos.src_idGROUPBYa.src_idORDERBYa.src_id版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。