Eclipse Community Forums: EclipseLink » Getting Double instead of BigDecimal when using EntityManager#createNativeQuery()

Home » Eclipse Projects » EclipseLink » Getting Double instead of BigDecimal when using EntityManager#createNativeQuery()

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

Getting Double instead of BigDecimal when using EntityManager#createNativeQuery() [message #642932]

Fri, 03 December 2010 11:57

Mik

Messages: 3
Registered: August 2010

Junior Member

Hello,
I am executing SQL statements via the JPA EntityManager's method createNativeQuery().

For numerical data (decimals) in the database I get BigDecimals within my Java programm.

Is there a way to tell JPA to return these values as Doubles instead of as BigDecimals?

Regards,
Mik

Report message to a moderator

Re: Getting Double instead of BigDecimal when using EntityManager#createNativeQuery() [message #643356 is a reply to message #642932]

Mon, 06 December 2010 15:51

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

For a raw native query, no, whatever the database returns is returned.

If you define the native query to return an Entity, then the types will be automatically converter to the Entity's types.

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Previous Topic:	Union
Next Topic:	Using Extensions for Schema Generation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 02 16:39:48 GMT 2020

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter