4 Replies Latest reply on Oct 6, 2006 12:07 PM by Pete Muir

    Multiple POJO Custom JSF DataTable

    johnurban Newbie

      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?