Hibernate Community • View topic - OneToMany - filter the mapped table results

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

OneToMany - filter the mapped table results

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

depy

Post subject: OneToMany - filter the mapped table results

Posted: Tue Jun 23, 2009 2:38 am

Newbie

Joined: Fri Jun 20, 2008 6:23 am
Posts: 6

I have two tables. Table A and B. Table A is a main table of objects and table B has statistics for table A (many records with timestamps and so on). So now I have mapped A and B with OneToMany on A side and want to filter the B results when table A gets loaded from database.

This is in class Game (table A). GameStatistics is table B.

Code:

@OneToMany(fetch=FetchType.EAGER, cascade=CascadeType.ALL)
@JoinColumn(name="gameid")
@OrderBy(value="datetime")
private Set<GameStatistics> gameStatistics;

So when I load entity Game I want to sort/filter results of GameStatistics (for example by date/timestamp).

Is it possible?

Top

senthil_rect

Post subject: Re: OneToMany - filter the mapped table results

Posted: Tue Jun 23, 2009 4:59 am