ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Karen Koch <kmk...@sbcglobal.net>
Subject Re: [ResultMap] Can't get primitive types to work
Date Fri, 18 Feb 2005 14:55:01 GMT
Are you perhaps missing the parameterClass arg on the statement itself?

--- Mike Zatko <mzatko@boscovs.com> wrote:

> /*I have a table as follows:*/
> 
> sqltype               sqllen  sqlname.data                    sqlname.length
>  --------------------  ------  ------------------------------  
> --------------
>  492   BIGINT               8  
> PROMO_ACTION_ID                             15
>  492   BIGINT               8  
> PROMOTION_ID                                12
>  452   CHARACTER            1  
> ACTIONTYPE                                  10
>  497   INTEGER              4  
> MIN_ITEM_QUANTITY                           17
>  485   DECIMAL          20, 5  
> MIN_SINGLE_ITEM_VALUE                       21
>  485   DECIMAL          20, 5  
> MIN_TOTAL_ITEM_VALUE                        20
>  485   DECIMAL          20, 5  
> MIN_ORDER_VALUE                             15
> 
> 
> /*I have the following ResultMap*/
> 
>     <resultMap id="getPromotionActionMap" 
> class="com.boscovs.commerce.promotion.dao.ActionDAO">
>         <result property="type" column="actiontype" />
>         <result property="numberOfItems" column="min_item_quantity" 
> javaType="int"/>
>         <result property="individualItemValue" 
> column="min_single_item_value" javaType="double"/>
>         <result property="totalItemValue" column="min_total_item_value" 
> javaType="double"/>
>         <result property="totalValue" column="min_order_value" 
> javaType="double"/>
>     </resultMap>
> 
> 
>     <select id="getPromotionAction" resultMap="getPromotionActionMap">
>         <![CDATA[Select a.actiontype, a.min_item_quantity,
>             a.min_single_item_value,
>             a.min_total_item_value,
>             a.min_order_value
>             from DB2USR.PROMOTION as p, DB2USR.PROMO_ACTION a
>             where p.promotion_id = a.promotion_id
>             and p.promotion_id = #value#
>             and p.status='A']]>
>     </select>
> 
> 
> /*My bean is as follows*/
> 
> public class ActionDAO {
>    
>     public static enum Selected {
>         UNSELECTED, NO_ACTION, ADDS_X_ITEMS, TOTAL_ORDER_VALUE_AT_LEAST_X
>     }
>    
>     private Selected selected = Selected.UNSELECTED;
>     private XItems xItems;
>     private double totalValue;
>     private int numberOfItems;
>     private double individualItemValue;
>     private double totalItemValue;
>     private String type;
>    
>    
>     /**
>      * @return
>      */
>     public Selected getSelected() {
>         return selected;
>     }
> 
>     /**
>      * @return
>      */
>     public double getTotalValue() {
>         return totalValue;
>     }
> 
>     /**
>      * @return
>      */
>     public XItems getXItems() {
>         return xItems;
>     }
> 
>     /**
>      * @param i
>      */
>     public void setSelected(Selected i) {
>         selected = i;
>     }
> 
>     /**
>      * @param d
>      */
>     public void setTotalValue(double d) {
>         totalValue = d;
>     }
> 
>     /**
>      * @param items
>      */
>     public void setXItems(XItems items) {
>         xItems = items;
>     }
> 
>     public void setType(String type) {
>         this.type = type;
>     }
>    
>     public double getIndividualItemValue() {
>         return individualItemValue;
>     }
>     public void setIndividualItemValue(double individualItemValue) {
>         this.individualItemValue = individualItemValue;
>     }
>     public int getNumberOfItems() {
>         return numberOfItems;
>     }
>     public void setNumberOfItems(int numberOfItems) {
>         this.numberOfItems = numberOfItems;
>     }
>     public double getTotalItemValue() {
>         return totalItemValue;
>     }
>     public void setTotalItemValue(double totalItemValue) {
>         this.totalItemValue = totalItemValue;
>     }
>     /**
>      * toString method: creates a String representation of the object
>      * @return the String representation
>      * @author
>      */
>     public String toString() {
>         StringBuffer buffer = new StringBuffer();
>         buffer.append("ActionDAO[");
>         buffer.append("individualItemValue = ").append(individualItemValue);
>         buffer.append(", numberOfItems = ").append(numberOfItems);
>         buffer.append(", selected = ").append(selected);
>         buffer.append(", totalItemValue = ").append(totalItemValue);
>         buffer.append(", totalValue = ").append(totalValue);
>         buffer.append(", type = ").append(type);
>         buffer.append(", xItems = ").append(xItems);
>         buffer.append("]");
>         return buffer.toString();
>     }}
> 
> 
> 
> /*I get an IllegalArgumentException from all this query. The developers 
> guide infers that you can use primitives in your definitions. Does it? 
> Or am I doing something stupid and not realizing it? BTW, it works if I 
> use Wrapper classes, but I don't want to have to go through all of my 
> beans and covert them. Thanks for any help.*/
> 


Mime
View raw message