Eclipse Community Forums: EclipseLink » Query Money/BigDecimal Datatype

Help

Home

Home » Eclipse Projects » EclipseLink » Query Money/BigDecimal Datatype(Query Money/BigDecimal Datatype)

Show: Today's Messages :: Show Polls :: Message Navigator

Query Money/BigDecimal Datatype [message #990849]

Fri, 14 December 2012 07:59

sahkiuvl v
Messages: 1
Registered: December 2012

Junior Member

I am trying to query a table for finding a MRP price.

BigDecimal mpr = 5.5;

Query query = em.createQuery("SELECT p FROM Product p WHERE p.mrp=:mrp");
query.set("mrp",mrp);

in the above i get a error

Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: money = numeric

in normal sql syntax i would be using

select * FROM a.product WHERE mpr='5.5';

So now my question is how do i frame the search for a Money DataType in the database.

Report message to a moderator

Re: Query Money/BigDecimal Datatype [message #991520 is a reply to message #990849]

Wed, 19 December 2012 11:32

James Sutherland
Messages: 1834
Registered: July 2009

Senior Member

I would recommend using NUMERIC instead of MONEY.

Postgres does not seem to allow BigDecimal to be bound to a MONEY column, you will need to figure out what type is wants, and use a Converter to convert to this type.

You could also disable parameter binding for this query ("eclipselink.jdbc.bind-parameters"="false"), as dynamic queries seem to work.

James : Wiki : Book : Blog

Report message to a moderator

Previous Topic:	Multitenancy + Tenants hierarchy
Next Topic:	hooks

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 04:55:06 EDT 2013