I have a java.util.Date field in an @Entity and would like to get the distinct months from that column.
I managed (as you can see in older posts from me) to insert a onetomany relation through hibernate. My two entity classes look like following:
I have Hibernate Objects defined as Class SomeText{ private Long textId; private Set<Tag> Tags = new HashSet<Tag>();
I am trying to execute a pretty-sophisticated query on a string field in the database. I am not very experienced at JPQL, so I thought I would try to get some help.
I intended to provide my view/business layer with the possibility to send HQL queries in strings to my data layer.
I want to backup HSQLDB from grails, Here\'s the c开发者_开发百科ommand BACKUP DATABASE TO \'C:/BACKUP/\' BLOCKING
I create 3 tables by Hibernate, how to return a List<task> when set task_status = ?and set create_user_id = ?, task_status in \"dotask\" table, create_user_id in task table.
I\'m writing an HQL query, in the form of: from a where ... or exists (from b inner join b.c where ...) and ...
I have spent several hours with this SQL problem, which I thought would be easy - I still think it should be, but obviously not easy enough for me (not an SQL expert). I would be glad if you could hel
I am using Castle ActiveRecord for my application. My 开发者_运维知识库problem is how to use a datetime string in HQL like this (without using parameters):