我也出现一个连接问题,现在不知道怎么解决, select a.name,a.jobnum,a.password,b.name,a.id,a.status,a.role_id,c.rolename from (Teacher a a left outer join Department b on a.department_id=b.id )left outer join Role c on c.id=a.role_id where a.status=1 order by a.id desc Oracle 可以用,HQL居然报ERROR - line 1:82: unexpected token: ( 求解脱啊
HQL带的连接语句只能是实体与该实体的属性 进行连接
其意义就是为了优化(通过延迟加载查询关联的属性实在太傻逼了..)
我知道的就这些 期待其他人补充 你也可以用SQL查询然后addEntity
select a.name,a.jobnum,a.password,b.name,a.id,a.status,a.role_id,c.rolename from (Teacher a a left outer join Department b on a.department_id=b.id )left outer join Role c on c.id=a.role_id where a.status=1 order by a.id desc
Oracle 可以用,HQL居然报ERROR - line 1:82: unexpected token: (
求解脱啊