But what about Transaction demarcation, where does JTA come into play?
On 4/6/06, Leon Rosenberg <[EMAIL PROTECTED]> wrote: > > to complete to Joes very good suggestion: the business manager returns > service an object/list of objects which are in no way associated with > objects used in dao. The typical name for this kind of object would be > a TicketDTO. The struts action maps each TicketDTO into a TicketBean, > which is the only object known in the jsp. This way you'll get stable > layers and don't rely on the db design in the jsp and vice versa. > > regards > Leon > > On 4/6/06, Joe Germuska <[EMAIL PROTECTED]> wrote: > > JSTL SQL calls don't conform to MVC principles in any way at all. > > > > I'd suggest creating a business manager service in Spring which has > > access to the two DAOs and having a Struts action call a single > > method on that business manager. This one sounds like read only, > > but if you have write operations, this allows you to use Spring's > > declarative transaction handling to integrate both databases into a > > single transaction. > > > > hope this helps... > > > > Joe > > > > > > At 4:09 PM -0500 4/6/06, olonga henry wrote: > > >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 > > > > > > -- > > Joe Germuska > > [EMAIL PROTECTED] * http://blog.germuska.com > > > > "You really can't burn anything out by trying something new, and > > even if you can burn it out, it can be fixed. Try something new." > > -- Robert Moog > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >