Top "Hql" questions

Use this tag for questions concerning "Hibernate Query Language" (HQL), a query language used by Hibernate and NHibernate.

HQL to query records between two dates

I am trying to query all customers records using HQL in my Spring/ Hibernate app that have DateAdded between Date1 …

spring hibernate hql
Hibernate HQL query by using like operator

Seu the following mapping @Entity public class User { private Integer id; @Id; private Integer getId() { return this.id; } } Notice id …

hibernate hql sql-like
How do I use the current date in an HQL query with an Oracle database?

I'm trying to write this query using Hibernate 3 and Oracle 10. from Alert alert where alert.expiration > current_date() order …

oracle hibernate hql
HQL query for entity with max value

I have a Hibernate entity that looks like this (accessors ommitted for brevity): @Entity @Table(name="FeatureList_Version") @SecondaryTable(name="…

java hibernate hql
Hive cluster by vs order by vs sort by

As far as I understand; sort by only sorts with in the reducer order by orders things globally but shoves …

hadoop hql hive
Hibernate query for selecting multiple values

In hibernate I can do following Query q = session.createQuery("from Employee as e); List<Employee> emps = q.…

java hibernate hql
Inner Joins Query in HQL

I'm unable to execute HQL for Inner Joins, Query is executing correct at sql but not in HQL. I don't …

java sql hibernate hql
How to write a like query in HQL

I want to perform search for a particular string that is starting with a particular alphabet. So, for example if …

hibernate hql
How to perform date operations in hibernate

I want to perform data time operations using hibernate HQL. I want to add and subtract two dates as well …

hibernate date time hql
Using HQL to query on a date while ignoring the time on Oracle

I have a table (in Oracle 9 and up) where I need to find all entries for a given day using …

hibernate date timestamp hql