English 中文(简体)
Hibernate: Plaing with Join
原标题:Hibernate: sorting with Join

我有两个表格:resumeIdCandidateInfo

String sql_query = "from shared.SelectedResumes as sr " +
                   "join sr.resumeId as cri " +

// 1st statement  
if (sortField.equals("resumeText")) {
    sql_query = sql_query + "order by cri.resumeText " + sortDirection;
}
// 2nd statement
else if(sortField.equals("cities")) {
    sql_query = sql_query + "order by ci.candidateInfo.cities " + sortDirection;
}

我的第1次发言是细致的,但第2次发言并不奏效,因为cities不在ci(即resumeId)中(与resumeId合并)。

如何从<条码>中获取>?

最佳回答

工作

from shared.SelectedResumes as sr join sr.resumeId as cri join cri.candidateInfo as ci
问题回答

暂无回答




相关问题
Multiple Hibernate instances using C3P0

I am facing a weird problem and it seems to be c3p0 related. I am starting two instances of an app in the same java vm which interact with each other. After some operations "APPARENT DEADLOCK" ...

Hibernate vs Ibatis caching

We can speed up a hibernate app easyly with 2nd level cache using infinispan or ehcache/terracotta,... but ibatis only have a simple interface to implement for caching. And hibernate knows more ...

Using annotations to implement a static join in hibernate

I m relatively new to hibernate and was wondering if someone could help me out. While I have no issues implementing a normal join on multiple columns in hibernate using the @JoinColumns tag, I m ...

Hibernate query with fetch question

I have a 2 entities in a One-To-Many relationship: OfficeView.java: public class OfficeView implements java.io.Serializable { private Integer officeId; private String addr1; private ...

hibernate interceptors : afterTransactionCompletion

I wrote a Hibernate interceptor : public class MyInterceptor extends EmptyInterceptor { private boolean isCanal=false; public boolean onSave(Object entity, Serializable arg1, Object[] arg2, String[]...

How to prevent JPA from rolling back transaction?

Methods invoked: 1. Struts Action 2. Service class method (annotated by @Transactional) 3. Xfire webservice call Everything including struts (DelegatingActionProxy) and transactions is configured ...

Hibernate/GORM: collection was not processed by flush()

I have an integration test in my Grails application that fails when I try to save an entity of type Member invitingMember.save(flush: true) This raises the following exception org.hibernate....

Hibernate Criteria API equivalent for "elements()"

Is it possible to implement the following query using Criteria API? select order from ORDER as order,ITEM as item where item.itemID like ITM_01 and item in elements(order.items)

热门标签