Re: SQLMAP IBATIS insert values from web forms to a money

>
> I think you should use BigDecimal ...
>
>
I tried java.math.BigDeciaml. It does not work for me, I still get the
exceptions:
column "salary_amount" is of type money but expression is of type numeric

>
> Emi Lu wrote:
>> Hello,
>>
>> I am using SQLMAP ibatis to do DB insertion for a webapplication.
>>
>> In my sqlmap.xml file, I was trying to insert values into a table
>> with one col (type is Money), but in java, I could not find Money type.
>>
>> Does someone knows about ibatis how to make values got from the web
>> form to be inserted into money type column through IBATIS ?
>>
>> Thanks a lot!
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 1: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>> message can get through to the mailing list cleanly
>>
>>
>>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match