Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
The Software Craftsman
this week in the
Object Relational Mapping
I want to join three tables using DetachedCriteria
Joined: Dec 26, 2008
Dec 29, 2008 01:58:00
I have three tables, namely Table1.class, Table2.class and Table3.class
They are each related to each other by foreign key references, say
I want to join these three tables to get columns C1,C2,C3...using DetachedCriteria and Projections...Any help is appreciated.
Thanks in advance
Joined: Jun 06, 2007
Dec 29, 2008 21:04:00
"mansi speaking" welcome to Javaranch
please check your private messages for an important administrative matter. You can see them by clicking the
My Private Messages
Asking Good Questions
Joined: Jun 23, 2009
Jun 23, 2009 23:15:32
Can any one help me an execution this query having JOIN using DetachedCriteria .
There two diffrent Table.
query = "select snmpinterface.ipaddr, snmpinterface.snmpifdescr, snmpinterface.snmpifspeed, snmpinterface.snmpifindex, snmpinterface.snmpifname, snmpinterface.snmpphysaddr from ipinterface, snmpinterface where ipinterface.ismanaged='M' and snmpinterface.nodeid = ipinterface.nodeid and snmpinterface.snmpifindex = ipinterface.ifindex and snmpinterface.nodeid = '" +routerName +"'";
String query = "select deviceID, advnet_deviceName, CI_ID, CustomerId from devices , categories where devices.isActive = 1 and categories.categoryName='Router' and devices.subCategory = categories.id and domain_manager_id = "+domainManagerID;
Thanks in advance for any help you can give to me.I am waiting your reply..
It is sorta covered in the
JavaRanch Style Guide
subject: I want to join three tables using DetachedCriteria
Trinidad Nested Tables Collapse and Expand Functionality Change
Hibernate one-to-many, one-to-one association not selecting records without children
merging two lists inside a list
Hibernate - how to map cross-table dependence?
database design help needed
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015