unexpected token异常

最新推荐文章于 2024-08-21 18:14:08 发布
最新推荐文章于 2024-08-21 18:14:08 发布
阅读量1.9k 收藏
点赞数
文章标签： Java Web Hibernate
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u010081052/article/details/83971310
版权
在开发中需要输入查询，遇到了下面的异常信息 


org.hibernate.hql.ast.QuerySyntaxException: unexpected token: % near line 1, column 550 [select bmb.bombId,bmb.userid,bmb.bombType,bmb.bombState,bmb.bombRead,b.bomId,b.bomTopic,b.userid,b.bomRecList,b.bomCopyList,b.bomSecList,b.bomTime,b.bomState,bmb.bomfId,f.bomfName,bbu.userName,bbu.userAccount,bbu.empId,s.userName,s.userAccount from net.bolue.oa.vo.BlOaMailBox as bmb left outer join bmb.bm as b left outer join bmb.bmf as f left outer join bmb.blBasicUser as bbu left outer join b.sender as s where 1=1 and bmb.userid=:userid and bmb.bombType=:bombType and bmb.bombState=:bombState and bmb.bombRead=:bombRead and s.userAccount like %超级管理员% order by b.bomTime desc]
	at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
	at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
	at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
	at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:284)
	at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:182)
	at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
	at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
	at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
	at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
	at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770)
	at net.bolue.oa.dao.impl.BlOaMailBoxDAOImpl.selectByAll(BlOaMailBoxDAOImpl.java:274)
	at net.bolue.oa.service.impl.BlOaMailServiceImpl.findList(BlOaMailServiceImpl.java:164)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	at $Proxy18.findList(Unknown Source)
	at net.bolue.oa.action.BlOaMailAction.receiveList(BlOaMailAction.java:127)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)
	at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at net.bolue.util.AccessFilter.doFilter(AccessFilter.java:48)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)
	at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
	at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555)
	at java.lang.Thread.run(Thread.java:619)


我的java代码是： 

Session session = getHibernateTemplate().getSessionFactory()
	.getCurrentSession();
StringBuffer queryString = new StringBuffer();
queryString.append("select    bmb.bombId,bmb.userid,bmb.bombType,bmb.bombState,bmb.bombRead," +
	"b.bomId,b.bomTopic,b.userid,b.bomRecList,b.bomCopyList,b.bomSecList,b.bomTime,b.bomState,bmb.bomfId,f.bomfName," +
	"bbu.userName,bbu.userAccount,bbu.empId,s.userName,s.userAccount" +" from BlOaMailBox as bmb left outer join bmb.bm as b left outer join bmb.bmf as f left outer join bmb.blBasicUser as bbu left outer join b.sender as s " +"where 1=1");

if (vo.getBomId() != null && !"".equals(vo.getBomId())) {
	queryString.append(" and bmb.bomId=:bomId");
}
if (vo.getUserid() != 0) {
	queryString.append(" and bmb.userid=:userid");
}
if (vo.getBombType() != null) {
	queryString.append(" and bmb.bombType=:bombType");
}
if (vo.getBomfId() != null&&vo.getBomfId() !=0) {
	queryString.append(" and bmb.bomfId=:bomfId");
}
if (vo.getBombState() != null) {
	queryString.append(" and bmb.bombState=:bombState");
}
if (vo.getBombRead() != null) {
	queryString.append(" and bmb.bombRead=:bombRead");
}
//按发送人查询
if(vo.getSendName()!=null&&!"".equals(vo.getSendName())){
	queryString.append(" and s.userAccount like "+"%"+vo.getSendName()+"%");
}
//按邮件发送时间排列
if(vo.getSortName()!=null&&vo.getSortName().equals("bomTime")&&vo.getSortorder()!=null&&!vo.getSortorder().equals("")){
	queryString.append(" order by b."+ vo.getSortName() +" "+ vo.getSortorder() );
}
//文件夹排列
if(vo.getSortName()!=null&&vo.getSortName().equals("folderName")&&vo.getSortorder()!=null&&!vo.getSortorder().equals("")){
	queryString.append(" order by f.bomfName "+ vo.getSortorder() );
}
//按是否已读状态排列
if(vo.getSortName()!=null&&vo.getSortName().equals("mailRead")&&vo.getSortorder()!=null&&!vo.getSortorder().equals("")){
	queryString.append(" order by bmb.bombRead "+ vo.getSortorder() );
}
//按发送人排列
if(vo.getSortName()!=null&&vo.getSortName().equals("senderName")&&vo.getSortorder()!=null&&!vo.getSortorder().equals("")){
	queryString.append(" order by s.userAccount "+ vo.getSortorder() );
}
//按邮件主题排列
if(vo.getSortName()!=null&&vo.getSortName().equals("bomTopic")&&vo.getSortorder()!=null&&!vo.getSortorder().equals("")){
	queryString.append(" order by b.bomTopic "+ vo.getSortorder() );
}
//按邮件类型排列
if(vo.getSortName()!=null&&vo.getSortName().equals("bomType")&&vo.getSortorder()!=null&&!vo.getSortorder().equals("")){
	queryString.append(" order by bmb.bombType "+ vo.getSortorder() );
}
Query q = session.createQuery(queryString.toString());

if (vo.getBomId() != null && !"".equals(vo.getBomId())) {
	q.setString("bomId", vo.getBomId());
}
if (vo.getUserid() != 0) {
	q.setLong("userid", vo.getUserid());
}
if (vo.getBombType() != null) {
	q.setInteger("bombType", vo.getBombType());
}
if (vo.getBomfId() != null&&vo.getBomfId() !=0) {
	q.setLong("bomfId", vo.getBomfId());
}
if (vo.getBombState() != null) {
	q.setInteger("bombState", vo.getBombState());
}
if (vo.getBombRead() != null) {
	q.setInteger("bombRead", vo.getBombRead());
}


导致错误的原因是28行，在这种情况下输入数字或英文可以通过，但是输入中文就报上面的错误。这可能是编码的问题，我却从另一个方面解决了这个问题：

将28行的代码也改成下面的形式 

queryString.append(" and s.userAccount like :sendName");

并且在后面也加上这段代码 

if(vo.getSendName()!=null&&!"".equals(vo.getSendName())){
	q.setString("sendName", "%"+vo.getSendName()+"%");
}


这样输入中文就可以通过了。
zengfa
关注
正确解决Unexpected token: operator xxxxx异常的有效解决方法
wbajsjhhhhh的博客
05-03 2926
正确解决Unexpected token: operator xxxxx异常的有效解决方法
org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: limit near line 1, column240
weixin_44131922的博客
06-26 1337
原因： sessionFactory.getCurrentSession().createQuery(sql);开启的是hibernate的面向对象语句所以不可以 解决反方式： 修改为 sessionFactory.getCurrentSession().createSQLQuery(sql)
org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: limit near line 1, column 80
程序员一代码搬运工
06-04 492
org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: limit near line 1, column 80 [ SELECT name FROM cla_hospital WHERE city='北京市' and name like '%北京%' limit 8 ] ...
JS SyntaxError: Unexpected token 报错解决
最新发布
qq_34419312的博客
08-21 6127
JS SyntaxError: Unexpected token 报错解决
QuerySyntaxException:unexpected token: ON [null] near line 1, column 135
icecoola_的博客
03-21 4084
Getting error that unexpected token: ON near line 1, column 135 解决方式： No defined association in hbm.xml file Hibernate HQL Inner Join Query query = session.createQuery("from Cat cat inner join...
Hibernate like查询 unexpected token: %
ch953181172的博客
11-23 1439
like '%a%'    要加引号
意外标记/unexpected token: LIMIT/@Query
a1243873089的博客
11-28 1468
在使用hibernate开发时,我们避免也会出现过在@query注解中手写sql,在使用"LIMIT"的时候会出现下面错误, Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: LIMIT near line 1, 解决: 加上nativeQuery=true @Query(value ...
Unexpected token c in JSON at position 0 报错信息及解决
01-20
在编程过程中，我们可能会遇到各种错误，其中"Unexpected token c in JSON at position 0"是一个常见的JavaScript解析错误，通常发生在尝试使用`JSON.parse()`函数解析一个预期为JSON格式的字符串时，但该字符串实际...
JS提示：Uncaught SyntaxError:Unexpected token ) 错误的解决方法
10-21
主要介绍了JS提示：Uncaught SyntaxError:Unexpected token ) 错误的解决方法,结合实例形式分析了javascript提示此类异常的常见原因与相关解决方法,需要的朋友可以参考下
解决vue打包后刷新页面报错：Unexpected token <
10-16
在使用Vue.js框架开发的项目中，打包后的静态文件部署到生产环境中时，遇到了页面刷新后报错“Unexpected token <”的问题。这个问题表明在解析index.html或者发生错误的页面时，解析器遇到了一个不符合预期的字符...
sql异常：Encountered unexpected token: “.“ “.“
mashangzhifu的博客
07-20 3万+
一、问题描述 在用mybatis-plus的过程中，没排序就好好的，一旦排序，报如下错误： net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "." "." at line 14, column 11. Was expecting one of: "&" "," "::" ";" "<<" ">>" "ACTION"
Unexpected token u
陈春春的技术博客
02-26 3319
今天在编写一个聊天室APP的时候，遇到一个莫名其妙的错误Unexpected token u，而且出错位置提示在index.html的第一行。 上网搜索资料后才发现，是我尝试JOSN.parse一个undefined对象导致的，解决办法就是如果为undefined就设置成null。null不会导致错误
ERROR org.hibernate.hql.PARSER:56 - line 1:75: unexpected token: a
我的成长之路！
07-13 8103
使用hibernate报错：ERROR org.hibernate.hql.PARSER:56 - line 1:75: unexpected token: a 原因：hql 语句有问题，比如查询条件少了什么。。
hdu 1213 How Many Tables（并查集+路径压缩）
Lzhzl211的博客
03-20 440
传送门 题目： Problem Description Today is Ignatius’ birthday. He invites a lot of friends. Now it’s dinner time. Ignatius wants to know how many tables he needs at least. You have to notice that not all the friends know each other, and all the friends do not wa
解决 Uncaught SyntaxError: Unexpected token ‘＜‘ 解决方法
热门推荐
HeXinT的博客
06-01 18万+
解决 Uncaught SyntaxError: Unexpected token ‘＜‘ 解决方法，打包出现的问题，解决方案
unexpected token: * 解决办法
09-28 4万+
02:13:01,413 ERROR [PARSER] line 1:8: unexpected token: * 02:13:01,417 ERROR [STDERR] java.lang.IllegalArgumentException: org.hibernate.hql
HQL子查询报错：org.hibernate.hql.ast.QuerySyntaxException: unexpected token...
Mr_sqw
06-17 1万+
HQL子查询报错：org.hibernate.hql.ast.QuerySyntaxException: unexpected token... HQL子查询只能出现在select或where字句中
Unexpected token ILLEGAL
09-02
"Unexpected token ILLEGAL"是JavaScript中的一个错误提示，意味着在代码中发现了非法的标记。这个错误通常是由于以下几种情况引起的： 1. 非法字符：代码中包含了非法的字符，比如特殊符号、中文字符等，这些字符在JavaScript中是不被允许的。要解决这个问题，需要检查代码中的字符，并删除或替换为合法的字符。 2. 编码问题：代码中包含了不被支持的编码格式，导致解析错误。要解决这个问题，可以尝试将代码文件的编码格式更改为合适的格式，比如UTF-8。 3. 代码格式错误：代码中存在语法错误，比如括号不匹配、缺少分号等。要解决这个问题，需要仔细检查代码，确保语法正确，并修复任何错误。 总结来说，"Unexpected token ILLEGAL"错误提示是由于JavaScript代码中存在非法字符、编码问题或语法错误引起的。要解决这个问题，需要检查代码并修复相应的错误。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* [js报Uncaught SyntaxError: Unexpected token ILLEGAL 异常问题](https://blog.csdn.net/itxiaolong3/article/details/79389179)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"] - *2* [JS提示：Uncaught SyntaxError: Unexpected token ILLEGAL错误的解决方法](https://download.csdn.net/download/weixin_38699593/13182290)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"] - *3* [Uncaught SyntaxError : Unexpected token ILLEGAL js错误](https://blog.csdn.net/qq_30979185/article/details/72461563)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"] [ .reference_list ]
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值