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

From Paul Thomas
Subject Re: SQLMAP IBATIS insert values from web forms to a money
Date
Msg-id 20060820211107.M11632@bacon
Whole thread Raw
In response to Re: SQLMAP IBATIS insert values from web forms to a money  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-jdbc
On 14/08/2006 15:06 Emi Lu wrote:
> 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

The PostgreSQL docs clearly state that money is a deprecated type and that
you should use numeric instead. Use a column type of numeric and a Java
type of BigDecimal.

--
Paul Thomas
+------------------------------+-------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for Business           |
| Computer Consultants         | http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+-------------------------------------------+

pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: Small problem with special characters
Next
From: Kris Jurka
Date:
Subject: Re: Small problem with special characters