Re: result map property as hashmap

2006-07-14 Thread Debasish Dutta Roy
you will need that if needed. I tried to give a normal scenario. Usually, you call a query obtain an id from that use that to call another query to get further details. Say, I call select * from employee. So I get dept id also which is a foreign key. Use this dept id to call select name from depart

Re: result map property as hashmap

2006-07-13 Thread Bing Lu
also I'm trying to do just one query in DAO I have queryForMap("getNames", null,"role","name"); and the xml is select ROLE, NAME FROM TABLE1 WHERE SEQNO=34567 but in my resultclass I'm getting null, if I run the query on the database itse

Re: result map property as hashmap

2006-07-13 Thread Bing Lu
so what does column="EMP_ID" do in here, does it pass onto the next query as parameter? --- Debasish Dutta Roy <[EMAIL PROTECTED]> wrote: > Yes you can do that. > In your first resultmap, you are going to provide > the > > --- First resultmap --- > select="getEmployeeDetails"/> > > The select

Re: result map property as hashmap

2006-07-13 Thread Debasish Dutta Roy
Yes you can do that.In your first resultmap, you are going to provide the --- First resultmap --- The select id "getEmployeeDetails" has a corresponding resultClass is a HashMap.So this way you will only call one query the first one and one of the result will be a hash map. On 7/13/06, Bing Lu <[EM

result map property as hashmap

2006-07-13 Thread Bing Lu
Hi, I have a resultmap that's matching to a class, one of the result property is going to be a hashmap populated from the database using another query, I'm so sure about how to write this out in the xml file. Can anyone help me out here? thanks a bunch