struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "olonga henry" <olon...@gmail.com>
Subject Re: MVC Dilemma
Date Fri, 07 Apr 2006 15:30:47 GMT
No, I am using Hibernate 3 and there are a lot of advantages you get from
using a complete ORM solution like this compared to Ibatis.
No, I am forced to use two databases Ticket (MySql) and Employee(AS/400,
legacy info).  I have no choice here.


On 4/7/06, Larry Meadors <lmeadors@apache.org> wrote:
>
> All you want is a list of tickets by employeeId with the employee name?
>
> You confused us all with the database term, I guess - if I am reading
> your question correctly, you mean two tables, not two databases (a
> database is a collection of tables).
>
> Keep it simple - use iBATIS (or jdbc) and put the results into a map:
>
> <select id='getTicketsByEmployeeId' resultclass="java.util.HashMap">
> select t.*, employee.name
> from ticket t
> join employee e on t.employeeId = e.employeeid
> where e.employeeid = #value#
> </select>
>
> Done. One (indexed and very fast) hit on the database and you are done.
>
> Larry
>
>
> On 4/7/06, olonga henry <olongax@gmail.com> wrote:
> > Neither. List of open tickets that can belong to any employee.
> > It's just happens that I want to display the name of the employee
> instead of
> > their Ids.  I have been telling this in every email.  But you people
> don't
> > seem to get this.
> >
> >
> >
> > On 4/7/06, Rick Reumann <struttin@reumann.net> wrote:
> > >
> > > olonga henry wrote the following on 4/7/2006 10:21 AM:
> > > > After getting the ticket list, I will have to read the employeeIds
> first
> > > in
> > > > memory then make those calls and put 'em in a hashmap so that I can
> > > disply
> > > > 'em properly in the hashmap.
> > >
> > > I've been following this thread, and it's amazing how overcomplicated
> > > people are making all of this. I'd love to know exactly from a "user's
> > > perspective" what you want to accomplish ologna. All of this "don't
> use
> > > a join" nonsense is just silly (to be polite:) Although, more than
> > > likely you don't need to get everything back on the initial display of
> > > your employees.
> > >
> > > Do you just want to display an Employee record and a list of tickets
> > > that belong to the employee????
> > >
> > > --
> > > Rick
> > > http://www.learntechnology.net
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> > > For additional commands, e-mail: user-help@struts.apache.org
> > >
> > >
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@struts.apache.org
> For additional commands, e-mail: user-help@struts.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message