Seam + <h:dataTable> using two datasources

[asookazian]

So we have a use case that needs to update 3 of the columns (datasource = table in RDBMS 1) and display 3 of the columns from a select based on joins on tables in RDBMS 2. All six columns are displayed simultaneously in the same dataTable.

What is the best way to handle the implementation of this case? Using entity beans or stored procs?

Anybody used EJB3 with entity beans to do this?

[asookazian]

How bout embedding two <h:dataTable> blocks inside the same <h:form> tag? Each looping thru a List of different entity beans?

[pmuir]

Get your JPA mappings correct and then use a single List to back the DataTable that contains the entities to update.

[asookazian]

Get your JPA mappings correct and then use a single List to back the DataTable that contains the entities to update.

so does this mean use one <h:dataTable> only for all entities in the List or multiple <h:dataTable> tags in the form?

[asookazian]

I don't understand how to use the dataTable with multiple entity beans. say for instance, a Customer entity and a creditcard entity (1:m relationship).

would it be a single dataTable? it doesn't seem that would work that way...

[pmuir]

I would use nested dataTables in this case (or perhaps a ui:repeat or something as nesting tables can look odd). seamdiscs example has iterated lists inside a dataTable.

[asookazian]

ok i will look at both. thx again!