[jboss-user] [JBoss Seam] - Multiple POJO Custom JSF DataTable

[johnurban]

Seam Design Question:

I need to create a jsf datatable view with data from 3 different tables. My sql would look something like this:

select t1.firstname, t1.lastname, t2.roomName, t3.secureCode
from person t1, room t2, attendance t3
where t1.roomId = t2.roomId
and t1.personId = t3.personId

My question: 

Is the best approach to create an Attendance entity(POJO) with firstname, lastname, roomname and securecode. Then create SFSB that executes the above SQL storing the data in a List of Attendance objects tying it back to the JSF?

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3976484#3976484

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3976484