hql

相关标签：javascript jquery android 多少钱 iPhone

Case statement with nested select in HQL

I\'ve problem to create a HQL statement for this SQL (Oracle). SELECT CASE WHEN Col开发者_如何学Pythonumn1 = \'VALUE1\' THEN ([详细]

2023-03-19 01:18 分类：问答
NHibernate HQL: How to use the new object constructor with 'distinct'?

I need to use the HQL object constructor feature, e.g: select new SomeClass(i.Id, i.Name) from Item i...[详细]

2023-03-18 18:04 分类：问答
Grails HQL vs SQL Statements

I would like an opinion about qu开发者_StackOverflow社区erying the database using HQL or SQL Statements, concerning simplicity, complexity and performance.With HQL you are operating on a class based d[详细]

2023-03-17 19:13 分类：问答
Sub-optimal queries over many-to-many relations with HQL

I have two entities, Location and Industry, and a link-table between them. I\'ve configured a many-to-many relationship, in both directions, between the two entities.[详细]

2023-03-17 19:02 分类：问答
How to execute the following SQL-Query using LINQ or HQL

How can I execute the following query using Castle ActiveRecords and LINQ or HQL? SELECT a.id, s.classes, COUNT(p.id), MAX(p.date) AS last, MIN(p.date) AS first[详细]

2023-03-17 10:50 分类：问答
Multi-table NHibernate query

I have an object graph that looks like this: class A () { int id; IEnumerable<B> bees; } class B() { int id;[详细]

2023-03-17 05:59 分类：问答
How can I make a dynamic Grails search?

Consider t开发者_开发知识库his domain class: class House { Integer room Integer bathroom Date builtDate[详细]

2023-03-16 22:27 分类：问答
Convert SQL to NHibernate HQL

I should convert to the fallowing SQL-Query to NHibernate HQL (NHibernate 3.2). But I don\'t know, how I have to translate the FLOOR, DATEDIFF and GETDATE.[详细]

2023-03-16 06:37 分类：问答
HQL Query - Castle Active Record - Outer Joins

I am trying to grab data from the DB of a particular table, where there is either no join to a another table, or there is but it isn\'t the right Data.[详细]

2023-03-15 19:07 分类：问答
How can i access values returned by Hibernate Query?

How can i access the elements from the list created as below? I tried creating a class containing a String and an int and cast to it but it doesn\'t work.[详细]

2023-03-15 07:44 分类：问答