I would recommend that you specify the jdbcType in your result.
<result property="numberOfItems" column="min_item_quantity"
jdbcType="INTEGER" javaType="int"/>
On Fri, 18 Feb 2005 06:55:01 -0800 (PST), Karen Koch
<[EMAIL PROTECTED]> wrote:
> Are you perhaps missing the parameterClass arg on the statement itself?
>
> --- Mike Zatko <[EMAIL PROTECTED]> 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.*/
> >
>
>
