Make sure that your public property name and the columns which you are retrieving from the query has got same names. Then it definitely works.
Nikhil Vaghela V2Solutions A New Vision to Solutions India: +91-22-56733201 ext 619 US : 1-408-454-6051 ext 219 http://www.v2solutions.com TZ : +5:30 GMT ________________________________ From: Jakub Scheibe [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 28, 2006 4:54 PM To: [email protected] Subject: Re: Dynamic ResultMaps When I'm using my class as a resultclass i'm only getting null values :( On 28/11/06, Nikhil Vaghela < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: Hi , In such situation you can use resultClass instead of resultMap , and in that case you should have your property [in your custom objects] names same as your query's fields name. Nikhil. ________________________________ From: Jakub Scheibe [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 28, 2006 4:42 PM To: [email protected] Subject: Dynamic ResultMaps Hi, Is there any way to create dynamic resultmaps? In this moment i'm preparing dynamic sql statement but I don't know how to prepare dynamic resultmap Here is how i'm doing this: <select id="Select" parameterclass="MyClass" resultmap="MyResMap"> select <dynamic> <isEqual property="Id" compareValue="1"> ID </isEqual> <isEqual property="Name" compareValue="true" prepend=","> NAME </isEqual> </dynamic> from MYTBL </select> if I use following resultmap it working ok but i need to use both Id and Name in Select <resultMap id="MyResMap"> <result property="Id" column="ID"/> <result property="Name" column="Name"/> </resultMap> Regards, Jakub
