Hi Guys
This is my first post so hopefully someone can help me here. I need to retrieve data which is spread over two database tables (which are linked throught another table) so that I can display it in a JSP page but Im having difficulty with it...
The tables are as follows:
BIOGRAPHIC_DATA:id (PK)
title
forename
surname
user_id
(FORIEGN_KEY to USER.id)dob... ect...
USER:id (PK)
user_status
role... etc...
OPERATOR:id (PK)
username
password
user_id
(FORIEGN KEY to USER.Id)status
The fields I need to retreive are:
Code:
OPERATOR.id
BIOGRAPHIC_DATA.title
BIOGRAPHIC_DATA.forename
BIOGRAPHIC_DATA.surname
OPERATOR.username
OPERATOR.status
Given this schema, is it possible to use DetachedCriteria and make one single call to
Code:
findByCriteria(detachedCriteria, offset, maxRecs)
and return me the set of records that I need.
Our codebase currently has a 'Retriever' per data object, so we have a BiographicDataRetriever, UserIdentityRetreiver, OperatorRetriever etc... Which one of these would be best to implement the code in...
Thanks for any help you can provide.
Regards
Martin
Login
FAQ
Search
