Hibernate Community • View topic - Creating HQL Query which works on Collections

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Creating HQL Query which works on Collections

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

ankisinghal

Post subject: Creating HQL Query which works on Collections

Posted: Mon Nov 10, 2008 11:32 am

Newbie

Joined: Thu May 29, 2008 6:24 am
Posts: 5

I am having following Model

Code:

Host

{
Long Id
String fqdn2
Set <HostDiscoveredReg > files
}

HostDiscoveredReg{

Long ID
Host hst
String filename

}

SoftwareRegFiles{

String filename

Set <SoftwareApps> apps

}


SoftwareRegApps{

String appName;

Set <SoftwareRegsFiles> files

}

Now I want to find the set of HostDiscoveredReg objects for a Set of Apps and Set of Hosts.

for given Set of Apps first we need to find set of SoftwareRegFiles and need to match the filename from SoftwareRegFiles to filename of HostDiscoveredReg and also match hst of HostDiscoveredReg to set of Hosts.

I am not able to create a HQL of this.

Can any one help me in this?

Ankit

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum