Top "Hql" questions

A simple question: In this example I need to retrieve all objects, but these objects must have distinct msgFrom fields. …

I want to execute the below query in Hibernate? select count(*) from login where emailid='something' and password='something'

I get List<Strings> by executing a query. This must be passed to another query of IN clause …

I'd like to use Hibernate's criteria api to formulate a particular query that joins two entities. Let's say I have …

I have the HQL where I trying to get artifacts that have no classification (when active is 0) artifacts = Artifact.findAll("…

i have a table Permission: id name desc what i am doing right now is to make a query that …

In my Hibernate JPA Sample code.. public List<AttendeesVO> addAttendees(String searchKeyword) { TypedQuery<AttendeesVO> query = entityManager.…

Is there any way to do the following in HQL: SELECT case when flag = true then SUM(col1) else SUM(…

Hibernate doesn't delete my row: public boolean deleteVote(Login user, int pid){ Session session = getSession(); try{ String hql = "delete from …

I need to combine 2 tables using hql, both are having common column, but table1 common column is integer and table2 …