hql
NHibernate Linq Query is 3x slower than HQL
I 开发者_如何学JAVAhave a simple test that runs a query 5000 times. The linq version of the query takes over 3 times the HQL and the cached Linq version is significantly slower than the cached version[详细]
2023-03-11 15:55 分类:问答HQL - need help on query
I have entities: Tweet and User. Tweet has an author, which is an instance of User class. User is following others users and also keeps track of users following him:[详细]
2023-03-11 02:13 分类:问答special characters in HQL
hi i\'m trying to get from a mySql DB a query using Hibernates HQL * public String getDetailsByUserAndFullPath(String user,String fullpath) {[详细]
2023-03-10 18:45 分类:问答Why this HQL is not valid?
The error is: Error: org.hibernate.QueryException: can only generate ids as part of bulk insert with either sequence or post-insert style generators[详细]
2023-03-09 22:18 分类:问答Its possible insert row with embedded ID on table with HQL?
I\'m able to insert any row with HQL. Example: insert into MyMappedTable(field,field,field) select c.x, c.y, c.z from Object c where ....[详细]
2023-03-09 08:35 分类:问答HQL query to filter date from datetime data
I want to convert datetime format to string format in HQL count. For example开发者_开发百科, I have redundant attendance data in each day of month of multiple employee which I need to count and get d[详细]
2023-03-09 05:07 分类:问答Nhibernate GroupBy multiple and Count
First off I know GroubBy multiple properties has not been implemented yet. What I want to do is SELECT count(*)[详细]
2023-03-08 08:35 分类:问答Hibernate 3.6: registerFunction in SQL dialect not working
I´m giving up and ask the community ... In my project, I´m using Hibernate 3.6.4.Final and a custom sql dialect:[详细]
2023-03-07 22:04 分类:问答HQL concat function
Customer{ String customerName @OneToMany Set users; } User{ String userName; } when i do this: select c.customerName as customerName ,concat(u.userName) as userNames from Customer c join c.user开[详细]
2023-03-07 21:58 分类:问答Find instance with at least one instance of a specified type in associated collection
I have an existing domain at work and haven\'t been able to limit the result of a query based on at least one instance of a specified type in an associated collection.[详细]
2023-03-07 07:02 分类:问答