Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 412
  • Last Modified:

tricky hql where clause

Hi,

I am trying perform select hql, but where clause is a bit tricky. I have two classes like this:
+++++++

public class Project extends ActionForm implements java.io.Serializable {

private Long projectId;
private Demographics demographics;
...
...

+++++++++++++

public class Demographics extends ActionForm implements java.io.Serializable {

    private Long demographicsId;//pk
    private Set projects = new HashSet(0);
...
...

+++++++++++

and it is 1 - N relastionship. I tried this in HQL editor, but didn't return anything.

FROM Project as project where project.demographics.demographicsId='1234'

What hql is going to look like in this case?

thx
0
dkim18
Asked:
dkim18
1 Solution
 
bgloddeCommented:
FROM Project as project where project.demographics.demographicsId='1234'

"demographicsId" is undoubtedly a numeric datatype of some sort, so you won't need single quotes
FROM Project as project where project.demographics.demographicsId=1234

If that doesn't set it straight, check your capitalizations and turn on the option:
<prop key="hibernate.show_sql">true</prop>
so you can see what Hibernate is generating for the actual query.

0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now