Top "Hql" questions

Hibernate: how to make EXISTS query? (not subquery)

For example: EXISTS ( SELECT * FROM [table] WHERE ... ) How to make such query using Hibernate?

hibernate hql

How to get last record from Mysql using Hibernate?

List<Lahetys> last = session.createQuery("from lahetys order by lahetysNro DESC LIMIT 1").list(); and in the log I …

mysql sql hibernate hql

"Not supported for DML operations" with simple UPDATE query

I'm getting the error Not supported for DML operations when I use the following HQL... @Query("UPDATE WorkstationEntity w SET …

java sql hibernate spring-mvc hql

HQL Equivalent of SQL Contains

I'm trying to write an HQL query to select objects which contain an object in a child collection. Example: Contest …

sql hql contains

Cannot convert '0000-00-00 00:00:00' to TIMESTAMP

the field definition /** Date. */ @Column(columnDefinition = "datetime") private Date date; setter public void setDate(final Date date) { DateFormat dfmt = new …

java hibernate date hql

Is there a more efficient way of making pagination in Hibernate than executing select and count queries?

Usually pagination queries look like this. Is there a better way instead of making two almost equal methods, one of …

java mysql hibernate pagination hql

Hibernate 5.2 version -> A lot of Query methods deprecate?

I'm new to Hibernate. I'm trying to get a list of first name and last name of all administrators. There …

java sql hibernate hql dao

How to query struct array with Hive (get_json_object) or json serde

I am trying to query the following JSON example file stored on my HDFS { "tag1": "1.0", "tag2": "blah", "tag3": "blahblah", "tag4": { "…

json hive hql hive-serde

How to convert HQL to SQL Query programmatically (without logging)

I am executing the following HQL and it is executing properly String hql = "FROM Employee"; Query query = session.createQuery(hql); …

java sql hibernate hql jpql

Hibernate HQL join fetch not recursively fetching

I have the following query and method private static final String FIND = "SELECT DISTINCT domain FROM Domain domain LEFT OUTER …

java hibernate jpa hql