hql
HQL / Nested Eager Loading
I am wondering what the best way is to load nested values for lazy loaded objects.I\'m providing an example to help explain this better.[详细]
2023-04-10 08:24 分类:问答Hibernate query on custom collection
I have a hibernate mapping with custom collection types in it. java: class Policy { ... private HistoryMap<Date, PolicyStatus> statusHistory;[详细]
2023-04-10 06:28 分类:问答ManyToMany relations in HQL
I\'ve got the following relations: public class Group { private Intege开发者_Python百科r id; (...) @ManyToMany(cascade=CascadeType.ALL)[详细]
2023-04-10 05:04 分类:问答Hibernate: SELECT in UPDATE
I need do something like that: session.getTransaction().be开发者_开发百科gin(); session.createQuery(\"update Pack p set p.book = (select b from Book b where ...) where p.id = :id\")[详细]
2023-04-09 14:35 分类:问答Optional parameter with setParameterList in HQL
I have a query with optional parameter \"SELECT ClinicId,Name from Clinic where :ClinicIds is NULL OR ClinicId IN :ClinicIds\"[详细]
2023-04-09 01:13 分类:问答HQL CASE statement usage
I\'m using HQL and have this query <query name=\"rule.myRule.query.by.name\"> <![CDATA[ FROM rule.myRule as cr[详细]
2023-04-09 00:23 分类:问答Calculating rank on an aggregate column in a Hibernate SQLProjection
I am trying to write a query to calculate a rank column based upon an aggregate column. The query is an SQLProjection as part of a Hibernate Criteria query. Here is what I have tried:[详细]
2023-04-07 16:57 分类:问答Inline expressions in HQL
What is the most effectiv开发者_如何学Pythone way to write this sql query in HQL select uar.*, (a.default_user_asset_role_id is not null) as is_defaultfrom User_asset_role uar[详细]
2023-04-07 10:10 分类:问答Custom order by string parameter in HQL
I had an HQL query like this: Query query = session.createQuery(\"from User as user where user.joined!=null order by user.joined desc\");[详细]
2023-04-07 09:50 分类:问答How can I select objects by list size in HQL?
My entity is defined like this: public c开发者_JS百科lass Entity implements Serializeable { @ManyToMany(mappedBy=\"entities\")[详细]
2023-04-07 02:46 分类:问答