Ive been working on an applicaiton where I want to store information about scholarships in several tables and let users search for a scholarship based on their personal criteria. To this end I have a scholarship table and several associated tables (right now they are sets of of strings). Im trying to query witihn those associated tables but have been thus far unable. I have been told to work with lazy associations but Im not sure thats answer. Ive started looking into joins and fetching to make sure hibernate goes and gets those associated tables but thats not working either. Then I ran across this from the hibernate documentation.
Quote:
A fetch join does not usually need to assign an alias, because the associated objects should not be used in the where clause (or any other clause). Also, the associated objects are not returned directly in the query results. Instead, they may be accessed via the parent object. The only reason we might need an alias is if we are recursively join fetching a further collection:
If one isnt supposed to use joined tables in the where, How does one search within a joined table?
For all my info please see my past topic on the same issue
http://forum.hibernate.org/viewtopic.ph ... highlight=
Login
FAQ
Search
