StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POGeneric DAO and nested properties support
primarykey
Id
12003143
data
AcceptedAnswerId
12043844
AnswerCount
2
ClosedDate
CommentCount
10
CommunityOwnedDate
CreationDate
2012-08-17T09:23:42.470
FavoriteCount
1
LastActivityDate
2016-03-27T22:35:31.063
LastEditDate
2012-08-20T08:53:04.830
LastEditorUserId
691916
OwnerUserId
691916
ParentId
0
PostTypeId
1
Score
1
ViewCount
2338
LastEditorDisplayName
text
Body
I am trying to perform a DB access through a DAO object, and I have bumped into the case where I need to query a field in another Entity. Considering two entities (EntityA and EntityB) that are connected in entity A through the foreign key <code>EntityA.idEntityB</code>. I have <code>GenericDao<EntityA> daoA</code> and I am trying to get all the results that match a determined field of EntityB: <code>idEntityB.fieldOfB</code> all in the same find method of the dao. Is it possible? And if so some directions would be nice. Thanks edit An example of my code: <h3>Entities</h3> <pre><code>public class EntityA { @JoinColumn(name = "id_entity_b", referencedColumnName = "id") @ManyToOne(optional = false, fetch = FetchType.EAGER) private EntityB idEntityB; // getter+setter... } public class EntityB { // ... private String fieldOfB; // getter+setter... } </code></pre> <h3>DAO Access</h3> <pre><code>GenericDao<EntityA> daoA = // ... Set<Criterion> filter = new HashSet<Criterion>(); filter.add(Restrictions.eq("idEntityB.fieldOfB")); List<EntityA> list = dao.findByFilter(filter); </code></pre> The error message is something like "Could not resolve property idEntityB.fieldOfB" edit 2 I was able to find something like what I want to do. Although my API is slightly different I believe this is helful for anyone who gets across this problem at an early stage of their own project. <a href="http://code.google.com/p/hibernate-generic-dao/" rel="nofollow">http://code.google.com/p/hibernate-generic-dao/</a> <blockquote> The framework features a powerful and flexible search functionality. This is used by passing a search object to search methods on general and generic DAOs. </blockquote> Searches with nested properties are fully supported in this project.
Tags
<java><hibernate><genericdao><hibernate-generic-dao>
Title
Generic DAO and nested properties support
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USnuno
UserOwnerUserId
1. USnuno
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POGeneric DAO and nested properties support
 UserUserId
 USdjmj
 VoteTypeVoteTypeId
 VTFavorite
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.