2023年12月8日发(作者：)

ception：处理排序失败：ne。。。

ception: 处理排序失败: xception: Encountered unexpected token: "DELAYED" "DELAYED" at line 3, column 19.

sSystemException: nested exception is tenceException:

### Error querying database. Cause: ception: 处理排序失败: rserException### The error may exist in cn/com/chinatelecom/ecms/dao/dev22/### The error may involve NetageGetBoonList_COUNT### The error occurred while handling results### SQL: select count(0) from (select ID,PHONENUMBER,GETTIME,BOONID,BOONNAME,BOONSTATE,GEARID,GEARNAME, PRIZETYPE,DELAYED,USEDTYPE,PRIZECOUNT,PRIZETIME from T_NETAGE_GETBOON

### Cause: ception: 处理排序失败: rserException at ateExceptionIfPossible(:77) at sionTemplate$(:446) at .$List(Unknown Source) at List(:230) at eForMany(:139) at e(:76) at (:59) at .$NetageGetBoonList(Unknown Source) at $1(:206) at tedCustomerServiceImpl$$Lambda$202/ct(Unknown Source) at ctPage(:348) at netageGetBoonList(:206) at 0(Native Method) at (:62) at (:43) at (:497) at JoinpointUsingReflection(:343) at Joinpoint(:198) at d(:163) at (:93) at d(:186) at (:212) at .$netageGetBoonList(Unknown Source) at tageGetBoonList(:114) at 0(Native Method) at (:62) at (:43) at (:497) at ke(:215) at ForRequest(:142) at AndHandle(:102) at HandlerMethod(:895) at Internal(:800) at (:87) at atch(:1038) at ice(:942) at sRequest(:998) at (:901) at e(:661) at e(:875) at e(:742) at alDoFilter(:231) at er(:166) at er(:52) at alDoFilter(:193) at er(:166) at er(:123) at alDoFilter(:193) at er(:166) at ChainProxy$er(:320) at (:127) at er(:91) at ChainProxy$er(:334) at er(:119) at ChainProxy$er(:334) at er(:137) at ChainProxy$er(:334) at er(:111) at ChainProxy$er(:334) at er(:170) at ChainProxy$er(:334) at er(:63) at ChainProxy$er(:334) at er(:155) at ChainProxy$er(:334) at er(:200) at ChainProxy$er(:334) at er(:116) at ChainProxy$er(:334) at erInternal(:66) at er(:107) at ChainProxy$er(:334) at er(:105) at ChainProxy$er(:334) at erInternal(:56) at er(:107) at ChainProxy$er(:334) at erInternal(:215) at er(:178) at Delegate(:357) at er(:270) at alDoFilter(:193) at er(:166) at erInternal(:200) at er(:107) at alDoFilter(:193) at er(:166) at erInternal(:147) at er(:81) at Delegate(:357) at er(:270) at alDoFilter(:193) at er(:166) at (:198) at (:96) at (:496) at (:140) at (:81) at (:650) at (:87) at e(:342) at e(:803) at s(:66) at ctProtocol$s(:790) at point$(:1459) at (:49) at ker(:1142) at PoolExecutor$(:617) at read$(:61) at (:745)Caused by: tenceException:

### Error querying database. Cause: ception: 处理排序失败: rserException### The error may exist in cn/com/chinatelecom/ecms/dao/dev22/### The error may involve NetageGetBoonList_COUNT### The error occurred while handling results### SQL: select count(0) from (select ID,PHONENUMBER,GETTIME,BOONID,BOONNAME,BOONSTATE,GEARID,GEARNAME, PRIZETYPE,DELAYED,USEDTYPE,PRIZECOUNT,PRIZETIME from T_NETAGE_GETBOON

### Cause: ception: 处理排序失败: rserException at ception(:30) at List(:150) at List(:141) at 0(Native Method) at (:62) at (:43) at (:497) at sionTemplate$(:433) ... 108 common frames omittedCaused by: ception: 处理排序失败: rserException at ToOrderBySql(:64) at eSql(:173) at eSql(:98) at ery(:168) at ept(:104) at (:61) at .$(Unknown Source) at List(:148) ... 114 common frames omittedCaused by: rserException: null at (:55) at ToOrderBySql(:52) ... 121 common frames omittedCaused by: xception: Encountered unexpected token: "DELAYED" "DELAYED" at line 3, column expecting one of: "(" "*" "+" "-" ":" "?" "@" "@@" "ACTION" "ANY" "CASCADE" "CASE" "CAST" "COLUMN" "COMMIT" "DO" "DOUBLE" "ENABLE" "END" "EXTRACT" "FIRST" "FOLLOWING" "GROUP_CONCAT" "IF" "INDEX" "INSERT" "INTERVAL" "KEY" "LAST" "LEFT" "MATERIALIZED" "NO" "NULL" "NULLS" "OPEN" "OVER" "PARTITION" "PERCENT" "PRECISION" "PRIMARY" "PRIOR" "RANGE" "REPLACE" "RIGHT" "ROW" "ROWS" "SEPARATOR" "SET" "SIBLINGS" "TABLE" "TEMP" "TEMPORARY" "TRUNCATE" "UNSIGNED" "VALUE" "VALUES" "XML" "{d" "{fn" "{t" "{ts" "~" at teParseException(:18047) at _consume_token(:17900) at Item(:3528) at ItemsList(:3368) at elect(:2930) at rationList(:3107)

at Body(:2824)

at (:2817)

at Statement(:133)

at ent(:81)

at (:53)

... 122 common frames omitted

ception: 处理排序失败: rserException

xception: Encountered unexpected token: "DELAYED" "DELAYED" at line 3, column 19.

　　

由于 DELAYED 是关键字，是 DELAYED 这个关键字引起的异常，两种解决方法：

　　　1.　一般就只需要将这个关键字 去掉 不进行获取，就不报异常，

　　 2. 可这个 DELAYED 字段，是需要进行获取出列值的表字段，

　　　　这时，就不在里面进行传递 排序，，直接在sql里面写死，就可以了，异常就解决了

　　

　　代码如下：

Page page = age(eNo(), eSize(), true)

　　　　　　　　　　　　　　　　　　　　　.doSelectPage(() -> ByExampleOfCon(example));

// .setOrderBy("GETTIME DESC").doSelectPage(() -> ByExample(example));

nt((int) al());

return new ArrayList<>(ult());

ID, PHONENUMBER, GETTIME, BOONID, BOONNAME, BOONSTATE, GEARID, GEARNAME, PRIZETYPE,

DELAYED, REMARK, USEDTYPE, PRIZECOUNT, PRIZETIME