Using Struts-Spring-Hibernate: I have a situation where I have to fetch a list of records from a table 'Ticket' (in database 1) in which a column is a employeeId so my action class calls the service layer which in turns calls the DAO layer to get the "Certain Tickets List".
Now, there is another table 'Employee' (in database 2) which contains employeeId and employeeName columns. In order to display the list of tickets with the employee names (in place of the employee Ids), I could have done a join if both the tables were in one database, which I cannot do in this case. I can make JSTL SQL calls to database 2 - Employee table to find the names at the view layer. But I would like to know if there are better alternatives out there which confirm to MVC principles. Thanx
