hql
NHibernate HQL distinct and order by
I\'ve recently upgraded from NHibernate 1.2 to 3.1 in an old code base. I\'ve fixed most problems b开发者_如何学运维ut I\'m stuck on this one. (I can\'t change from HQL to another access method withou[详细]
2023-03-06 22:16 分类:问答Hibernate HQL and fetching with grouping
We have a hibernate 开发者_如何学Cpojo Reporting/ReportingID that has several properties that contain counts, dates, actions, and devices.The device property mapped to a hibernate pojo called Device ([详细]
2023-03-06 19:20 分类:问答Want to fetch only 5 records with HQL [duplicate]
This question already has answers here: Closed 11 years ago. Possible Duplicate: How do you do a limit query in HQL[详细]
2023-03-06 13:03 分类:问答Restricting hibernate's eager fetch beyond DAO
I have my entities as ProductType,Product and ProductInventory. I have a join query to fetch list of inventory for a specific date range which joins Product and ProductInventory. I\'ve got list of ob[详细]
2023-03-06 05:46 分类:问答HQL query not working, Incorrect syntax near ',' error. Using Spring and Hibernate
I am trying to execute following update query and getting error, Query is= @Transactional public List<Order> getClosedOrders(String userID) throws DataAccessException {[详细]
2023-03-05 14:49 分类:问答Hibernate HQL or Criteria
I am new to hibernate. I saw some query example are written in HQL and some are written by us开发者_如何学编程ing criteria and projection. I googled around and found little information about when to u[详细]
2023-03-05 13:48 分类:问答Hibernate distinct clause problem
I search开发者_如何学编程ed a lot around but cannot find the answer: I have the following SQL query:[详细]
2023-03-04 13:57 分类:问答Ordering a join fetched collection in JPA using JPQL/HQL
Given the below JPQL statement, how do I modify it so that the kittens in the resulting list are ordered开发者_如何学编程 by their age property?[详细]
2023-03-04 12:29 分类:问答hibernate inner join
i need inner join with \"select rc.* from\" \"from RateCode rc inner join rc.rateCodeParams rcCod where rc.rateCodeId = rcCod.id and rc.travelFrom <= \'2011-05-09\' and rc.travelTo >= \'2011-[详细]
2023-03-04 02:49 分类:问答Hibernate query help
I have a Product Class which has one-to-many relationship with ProductInventory Class. For a particular product id, I have around 300 inventory.[详细]
2023-03-04 01:12 分类:问答