I have the following XML
entry
<resultMap id="result-tree1"
class="java.util.HashMap">
<result property="id" column="tree_id"/> <result property="screenName" column="screen_name" /> <result property="Name" column="name" /> <result property="column_id" column="tree_id" select="getColumnDetails" /> </resultMap> <!-- Fetches the
values based on the mapping -->
<select id="getTree2" resultMap="result-tree1" parameterClass="java.util.Map" > SELECT * FROM tree WHERE tree.tree_id = #id#<!-- when parameterMap is used ? has to be used --> </select> <select
id="getColumnDetails" resultClass="java.util.ArrayList"
parameterClass="int">
SELECT column_id FROM column_details WHERE tree_id = #value# </select> Where the resultMap has one entry
which is an arrayList.
The java method call is
Map param = new
HashMap();
param.put("id",new Integer(90)); Map tree = (HashMap)
sqlMap.queryForObject("getTree2",param);
But it throws
executeQueryForObject() returns too many rows Exception..
How to go about
it?? |
- SQLMap - Fetching ArrayList within an HashMap result srividhya umashanker
- Re: SQLMap - Fetching ArrayList within an HashMa... Vamsee Kanakala
- Re: SQLMap - Fetching ArrayList within an Ha... srividhya umashanker
- Re: SQLMap - Fetching ArrayList within a... Vamsee Kanakala
- Re: SQLMap - Fetching ArrayList within an HashMa... srividhya umashanker
- Re: SQLMap - Fetching ArrayList within an Ha... Clinton Begin
- SQLMap - Fetching ArrayList within an HashMap re... srividhya umashanker