select new SobUser (u.id,u.userName,u.roles,u.avatar,u.email,u.sign,u.state,u.repIp,u.loginIp,u.creatTime,u.updataTime) from SobUser as u"
b报错,2020-08-09 11:07:45.970 ERROR 15740 --- [nio-8080-exec-4] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: as near line 1, column 171 [select new SobUser (u.id,u.userName,u.roles,u.avatar,u.email,u.sign,u.state,u.repIp,u.loginIp,u.creatTime,u.updataTime) from org.example.blog.pojo.SobUser as u order by as.creatTime desc]; nested exception is java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: as near line 1, column 171 [select new SobUser (u.id,u.userName,u.roles,u.avatar,u.email,u.sign,u.state,u.repIp,u.loginIp,u.creatTime,u.updataTime) from org.example.blog.pojo.SobUser as u order by as.creatTime desc]] with root cause
我自己解决了,我把查询代码重新敲了一边就好了,莫名其妙的
log不全,看看有没有case by的地方。