Path expected for join解决
搬砖工人ql
2019-05-10 16:15:57
226
收藏
分类专栏：
Hibernate框架
最后发布:2019-05-10 16:15:57
首次发布:2019-05-10 16:15:57
版权声明：本文为博主原创文章，遵循<a href="http://creativecommons.org/licenses/by-sa/4.0/" target="_blank" rel="noopener"> CC 4.0 BY-SA </a>版权协议，转载请附上原文出处链接和本声明。
本文链接：
https://blog.csdn.net/qq_25378657/article/details/90074132
版权
查看下Hibernate的API文档，HQL语句对于join不识别，只要换成","逗号就可以了。
点赞
评论
分享
x
海报分享
扫一扫，分享海报
收藏
打赏
打赏
搬砖工人ql
你的鼓励将是我创作的最大动力
C币
余额
2C币
4C币
6C币
10C币
20C币
50C币
确定
举报
关注
关注
一键三连
点赞Mark关注该博主, 随时了解TA的最新博文
已标记关键词
清除标记
HQL left
join
出错
ping_2009的专栏
12-21
502
<br />今天开发的时候，写HQL语言的时候，用到了left
join
，因为这两个表之间并没有建立映射关系，所以就出现了执行时提示
path
出错的问题，最后还是用了where来代替的。比较郁闷~~~<br />哪天有时间了好好研究研究
插入表情
添加代码片
HTML/XML
objective-c
Ruby
PHP
C
C++
JavaScript
Python
Java
CSS
SQL
其它
还能输入
1000
个字符
“速评一下”
jpa antlr.SemanticException:
Path
expected
for
join
!
Jia__xin的博客
10-11
1325
jpa antlr.SemanticException:
Path
expected
for
join
! 在pom的标签中加入 <properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <project.reporting.out...
HQL不支持left
join
的变通方法(
Path
expected
for
join
!)
weixin_34413802的博客
03-24
546
2019独角兽企业重金招聘Python工程师标准>>> ...
hql语句左连接查询报错
Path
expected
for
join
!
03-21
String hql=" select new Map(o.id as id,o.regno as regno,o.uniscid as uniscid , o.entname as entname,o.lerep as lerep ,o.estdate as estdate,o.dom as dom, o.tel as tel , o.datasource as datasource ,d.nr as djjg ) from DataQyfrEntity o LEFT
JOIN
ABmDjjgEntity d with (d.bm=o.djjg) ";  ``` ```
国民度No.1，Python到底做了什么？
CSDN学院
01-20
1万+
毫无疑问，Python 是当下最火的编程语言之一。可以说 Python 的崛起，将编程提高了一个层次，它不再只是程序员专用，各个岗位都在学习 Python，导致普及度和国民度瞬间上升，Python 对整个行业来说都是极其有利的。 正如 TIOBE 官方评价：Python 无处不在，其实自 2018 年开始，各行各业便开始布局 Python。 在教育界， 1、自 2018 年 3 月起，在计算机二级考试加入了“Python 语言程序设计”科目； 2、2018 年，浙江省信息技术教材宣布弃用 VB 语言
hql语句左连接查询报错
Path
expected
for
join
!
03-21
String hql=" select new Map(o.id as id,o.regno as regno,o.uniscid as uniscid , o.entname as entname
-hibernate-
Path
expected
for
join
问题
05-23
提示
Path
expected
for
join
问题 如何
解决
,被困惑了很久 我的HQL: from tschool as a left
join
tclass as b with a.s_Id=b.
jpa使用left
join
的时候报错
05-17
springboot框架使用了jpa,写sql的时候使用了left
join
,然后报错: 数据库是postgreSQL antlr.SemanticException:
Path
expected
for
join
! at org.hibernate.hql.internal.ast.HqlSqlWalker.createFrom
Join
Element(HqlSqlWalker.java:385) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.
join
Element(HqlSqlBaseWalker.java:3903) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3689) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3567) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:708) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:564) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:301) at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:249) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:278) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:206) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:158) at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:131) at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:93) at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:167) at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:301) at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:236) at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1836) at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:328) at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:347) at com.sun.proxy.$Proxy141.createQuery(Unknown Source) at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:298) at com.sun.proxy.$Proxy138.createQuery(Unknown Source) at com.ido85.party.education.common.base.BaseApplication.queryPageEntityCount(BaseApplication.java:86) ........ 图片说明](https://img-ask.csdn.net/upload/201705/17/1495015427_349234.png)
hql的left
join
的时候出现：
Path
expected
for
join
!
02-26
我的hql是这样的 from BizDomain as a left
join
DevType as b where a.bizDomainId=b.bizDomainId 当这个hql写成 from
Hql连接查询的两个错误（
Path
expected
for
join
!和un
expected
token on）
微瞰技术的博客
08-31
621
1.
Path
expected
for
join
!
Path
expected
for
join
! [SELECT count() FROM cn.com.jsoft.entities.TDSysnphoto p left
join
TDSysnotice s where p.snid = s.id]; nested exception is org.hibernate.hql.ast.Query
[Hibernate 的left
join
]
Path
expected
for
join
!错误
weixin_30733003的博客
07-24
50
使用条件如下：a left
join
ba must be b's parent 转载于:https://www.cnblogs.com/timelyxyz/archive/2012/07/24/2549672.html
每日一得-org.hibernate.hql.ast.QuerySyntaxException:
Path
expected
for
join
!错误
解决
办法
hk540610的专栏
06-07
384
org.hibernate.hql.ast.QuerySyntaxException:
Path
expected
for
join
! HQL进行
JOIN
连接查询时需要注意几点： 1.HQL不支持ON，需要将ON换成WHERE 2.需要注明对象之间的映射关系 Product.hbm.xml映射文件如下： Product类中需要有 private Book book;
hibernate left
join
问题，比较急！！
04-01
是这样的一个问题， 有两张表A，B。 A表字段： id name1 number1 sex B表字段： id name2 number2 age sal 这里字段我是随便取的。 现在我要做这样一个操作
关于SSH多表联查sql语句中jion和
Path
expected
for
join
!的问题！
qq_43247798的博客
12-12
400
我的查询总共四个表:发票总表IV_Invoice 入库表IV_InInvoice 出库表IV_OutInvoice 交票表IV_Archive，然后对应关系就省略了。。。关系搭建的是没有任何问题的...直接看查询代码 //查询总表IV_InvoiceVo这个类是我查的所有数据封装类 public List<IV_InvoiceVo> findall() { ...
Hibernate Criteria 多表查询实体中有另一个实体 查询结果映射异常？
01-17
# Hibernate Criteria 多表查询 代码： 1. Affix类 ``` public class Affix { private int id; private String name; private String size; private Integer width; private Integer height; private Role role; ``` 2.Role 类 ``` public class Role { private int id; private String name; private String remark; ``` 3. mapping 配置 ``` <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd"> <hibernate-mapping package="com.cn.domain"> <class name="Affix" table="sys_affix" catalog="test"> <id name="id" column="id"> <generator class="native"></generator> </id> <property name="name" column="name" length="20"></property> <property name="size" column="size" length="50"></property> <property name="width" column="width" length="50" type="java.lang.Integer"></property> <property name="height" column="height" length="50" type="java.lang.Integer"></property> </class> <class name="Role" table="sys_role" catalog="test"> <id name="id" column="id"> <!-- 主键生成策略 --> <generator class="native"></generator> </id> <property name="name" column="name" length="20"></property> <property name="remark" column="remark" length="50"></property> </class> </hibernate-mapping> ``` 4.Dao层 ``` public class AffixDao { public List selectAffix(){ Session session = HibernateUtils.openSession(); session.beginTransaction(); Criteria criteria = session.createCriteria(Affix.class);//1.总的查询容器 criteria.createAlias("role","r"); criteria.add(Restrictions.eq("r.id", 1)); List list = criteria.list(); List<Affix> lists = list; System.out.println("查询结果条数："+list.size()); session.close(); return list; } } ``` 5.执行结果 org.hibernate.QueryException: could not resolve property: role of: com.cn.domain.Affix at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:62) at org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:56) at org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1753) at org.hibernate.loader.criteria.EntityCriteriaInfoProvider.getType(EntityCriteriaInfoProvider.java:39) at org.hibernate.loader.criteria.CriteriaQueryTranslator.get
Path
Info(CriteriaQueryTranslator.java:228) at org.hibernate.loader.criteria.CriteriaQueryTranslator.createCriteriaEntityNameMap(CriteriaQueryTranslator.java:212) at org.hibernate.loader.criteria.CriteriaQueryTranslator.<init>(CriteriaQueryTranslator.java:94) at org.hibernate.loader.criteria.CriteriaLoader.<init>(CriteriaLoader.java:71) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1760) at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:363) at com.cn.dao.AffixDao.selectAffix(AffixDao.java:45) at com.cn.dao.AffixDaoTest.testSelectAffix(AffixDaoTest.java:16) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) at org.junit.runners.ParentRunner.run(ParentRunner.java:363) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192) # 问题： 网上搜过好多类似的实例代码，别人都可以执行成功，我这里一直报role在Affix中映射异常，有没有大神可以指点一下？谢谢
程序出现：
Path
expected
for
join
问题
03-20
查询两个表的内容 表1、SmsRecharge 表2、MobileLocalInfo 查询语句：from SmsRecharge as s left
join
MobileLocalInfo as m
©️2020 CSDN
皮肤主题: 书香水墨
设计师:CSDN官方博客
返回首页
502
