Avoid resultMap for Selecting multiple columns from multiple tables

[mule_user <sg...@aol.com>]

 New to iBatis. 

I want to select two colums from TABLE_1 (e.g., COL_A and COL_B) and two
columns from TABLE_2 (e.g, COL_C and COL_D). These 4 columns (selected from
two separate tables) are attributes in MyObj.java (e.g attributeA,
attributeB, attributeC and attributeD) respectively. 

My questions:
1. Can I avoid writing lengthy resultMap entries and still accomplish the
above? I know that I can accomplish selection from a single table by not
writing resultMap entries.
2. If the answer to the above question is yes, I would like to verify; if
this magic is possible because of me specifing the attribute name of the
Java object beside the column name as:
T1.COL_A as attributeA,
T1.COL_B as attributeB,
3. If I did not have entry for resultMap and did not specify matching column
with matching attribute (as shown in point 2 above), was there any way for
iBatis to map database column to object attribute? If yes, is the
requirement is to have the same name of the column as to the name of the
attribute? This is just another question to better understand. It may not be
advisable, nor practical to have same name for the database column and
attribute name for the Java object. 
4. Can I use code similar to the one below and get the result in MyObj.java,
where MyObj.java has 4 attributes namely attributeA, attributeB, attributeC,
attributeD matching COL_A and COL_B from TABLE_1 and COL_C and COL_D from
TABLE_2 respectively. 

    <select
        id="myQuery"
        parameterClass="int"
        resultClass="MyObj"
    >
    	select
		T1.COL_A as attributeA,
                          T1.COL_B as attributeB,
                          T2.COL_C as attributeC,
                          T2.COL_D as attributeD
              from TABLE_1 as T1
              join TABLE_2 as T2
              on T1.COL_A= T2.COL_C
    </select>

-- 
View this message in context: http://www.nabble.com/Avoid-resultMap-for-Selecting-multiple-columns-from-multiple-tables-tp18927904p18927904.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

Re: Avoid resultMap for Selecting multiple columns from multiple tables

[mule_user <sg...@aol.com>]

Answer is yes. I tested it out.


mule_user wrote:
> 
>  New to iBatis. 
> 
> I want to select two colums from TABLE_1 (e.g., COL_A and COL_B) and two
> columns from TABLE_2 (e.g, COL_C and COL_D). These 4 columns (selected
> from two separate tables) are attributes in MyObj.java (e.g attributeA,
> attributeB, attributeC and attributeD) respectively. 
> 
> My questions:
> 1. Can I avoid writing lengthy resultMap entries and still accomplish the
> above? I know that I can accomplish selection from a single table by not
> writing resultMap entries.
> 2. If the answer to the above question is yes, I would like to verify; if
> this magic is possible because of me specifing the attribute name of the
> Java object beside the column name as:
> T1.COL_A as attributeA,
> T1.COL_B as attributeB,
> 3. If I did not have entry for resultMap and did not specify matching
> column with matching attribute (as shown in point 2 above), was there any
> way for iBatis to map database column to object attribute? If yes, is the
> requirement is to have the same name of the column as to the name of the
> attribute? This is just another question to better understand. It may not
> be advisable, nor practical to have same name for the database column and
> attribute name for the Java object. 
> 4. Can I use code similar to the one below and get the result in
> MyObj.java, where MyObj.java has 4 attributes namely attributeA,
> attributeB, attributeC, attributeD matching COL_A and COL_B from TABLE_1
> and COL_C and COL_D from TABLE_2 respectively. 
> 
>     <select
>         id="myQuery"
>         parameterClass="int"
>         resultClass="MyObj"
>     >
>     	select
> 		T1.COL_A as attributeA,
>                           T1.COL_B as attributeB,
>                           T2.COL_C as attributeC,
>                           T2.COL_D as attributeD
>               from TABLE_1 as T1
>               join TABLE_2 as T2
>               on T1.COL_A= T2.COL_C
>     </select>
> 
> 

-- 
View this message in context: http://www.nabble.com/Avoid-resultMap-for-Selecting-multiple-columns-from-multiple-tables-tp18927904p18963774.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.