| From: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | emilu(at)encs(dot)concordia(dot)ca |
| Cc: | David Gagnon <dgagnon(at)siunik(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: SQLMAP IBATIS insert values from web forms to a money |
| Date: | 2006-08-20 20:11:07 |
| Message-ID: | 20060820211107.M11632@bacon |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 |
+------------------------------+-------------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2006-08-21 03:03:17 | Re: Small problem with special characters |
| Previous Message | Tom Lane | 2006-08-20 18:15:48 | Re: Small problem with special characters |