Re: SQLMap - Fetching ArrayList within an HashMap result

Try using executeQueryForList. Your query probably is returning more than one row. On Sat, 19 Mar 2005 09:15:47 +0530, srividhya umashanker <[EMAIL PROTECTED]> wrote: > > > > > I have the following XML entry > > > > > >/> > > > >parameterClass="ja

SQLMap - Fetching ArrayList within an HashMap result

I have the following XML entry                  SELECT *  FROM tree  WHERE tree.tree_id = #id#           SELECT column_id  FROM column_details   WHERE tree_id = #value#   Where the resultMap has one entry which is an arrayList.       The java method call

SQLMap - Fetching ArrayList within an HashMap result

I have the following XML entry                  SELECT *  FROM tree  WHERE tree.tree_id = #id#           SELECT column_id  FROM column_details   WHERE tree_id = #value#   Where the resultMap has one entry which is an arrayList.       The java method ca

Re: SQLMap - Fetching ArrayList within an HashMap result

srividhya umashanker wrote: SELECT column_id FROM column_details WHERE tree_id = #value# So, there are multiple column_ids which have the same tree_id. In that case, you shouldn't be using "where tree_id = #value#". It should be "where tree_id in (#value1#, #value2#)" etc. Chan

Re: SQLMap - Fetching ArrayList within an HashMap result

D]> To: Sent: Saturday, March 19, 2005 9:55 AM Subject: Re: SQLMap - Fetching ArrayList within an HashMap result > srividhya umashanker wrote: > > > /But it throws executeQueryForObject() returns too many rows Exception../ > > // > > // > > /How to go about it??/

Re: SQLMap - Fetching ArrayList within an HashMap result

srividhya umashanker wrote: /But it throws executeQueryForObject() returns too many rows Exception../ // // /How to go about it??/ / / You should use queryForList, which will give a List of HashMaps. Vamsee.

SQLMap - Fetching ArrayList within an HashMap result

  I have the following XML entry                  SELECT *  FROM tree  WHERE tree.tree_id = #id#           SELECT column_id  FROM column_details   WHERE tree_id = #value#   Where the resultMap has one entry which is an arrayList.       The java method c