I have a webform where I need to show data from Several tables.
Employee, Department, LastPromotionDate,

LastPromotionDate is obtained from Promotion table (emp#, promotion, rank)
In addition there is a Dependent table(emp#, dependentssn)
Their is a claim table (dependentSSN, Claim#)


I need to be able to search on claim# and retrieve employees.


How do I map this ?
In Hibernate can I retrieve only selected columns.
In this case I need to return an EmployeeWebObject (EMP#,Department#,LastPromotionDate) (Note I need summary information from several tables)


Please help

Help.
Is it even possible to map a value Object for the web ?
thanks

We don't know what you want, but it seems you haven't read any documentation.

i think what he wants is a partial "view" of the object graph,
what is commonly called DTO,
what has been already discussed thousand times in the forum,
what is generally rejected by the community but also
what is used by many companies.
:(

So, whats the problem? "select new MyDTO(propertyA, propertyB, etc) from Foo"

hey, I've no problem lol, i think the post wasn't clear... just wanna help...

I apologize I am not very familiar with Hibernate and am trying to move our custom JDBC which is used for the web tier (DTO technology ) to use Hibernate .
Please let me know if this possible to do using Hibernate .
If so any pointers to the right place will help me out tremendously.


Thanks again

DTO is not a technology lol

1- you must think about a REAL domain model.
2- Then read carefully at least 3 times the doc
3- for porting use the example given by christian to "generate" dynamically the DTO your views need...

But it is possible.
Don't forget to understand the "persistence" aspect of hibernate, you'll see it's very powerfull.

Anthony

Table
Employee (ssn, name,deptname, city, current salary, last_promotion_id)
Dept(deptname, description)
Dependents(dependent ssn, employee_ssn, dependent name )
Promotion(promotion_id, ssn, promotitle,promodate)
Claims(claim_no, dependentssn)

Firstcolumn in every table is primary key

Employee my have 0..* Dependents
Dependents may have 0..* claims
Employee may have 1..* promotions



Given the above what I want in my DTO given one employee ssn is a query that returns EmployeeDTO with the following
Employee.SSN
Employee.name
Employee.Deptname
Promotion.promotitle (joined employee.last_promotion_id = promotion_id)



The second part of my question is I still need EmployeeDTD but my search criteria is claim_no.. like the sql below

select .Employee.SSN,Employee.Deptname,Promotion.promotitle
where ...
and exists ( select .. from claim , dependents
where emp.ssn= dependends.employee_ssn
and dependends.employee_ssn= claim.dependentssn)

Is this possible? what will the mapping look like .
Is the query above possible


If there is a better alternative please let me know.