Re: SQLMAP IBATIS insert values from web forms to a money - Mailing list pgsql-jdbc

From Emi Lu
Subject Re: SQLMAP IBATIS insert values from web forms to a money
Date
Msg-id 44E0836D.6030609@encs.concordia.ca
Whole thread Raw
In response to Re: SQLMAP IBATIS insert values from web forms to a money type  (David Gagnon <dgagnon@siunik.com>)
Responses Re: SQLMAP IBATIS insert values from web forms to a money  (Paul Thomas <paul@tmsl.demon.co.uk>)
List pgsql-jdbc
>
>  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@postgresql.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


pgsql-jdbc by date:

Previous
From: David Gagnon
Date:
Subject: Re: SQLMAP IBATIS insert values from web forms to a money type
Next
From: Oliver Jowett
Date:
Subject: Re: upgrading from pg74.216.jdbc3.jar to 8.1-407 JDBC 3