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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
