Eclipse Community Forums: EclipseLink

Help

Home

Home » Eclipse Projects » EclipseLink » SQL to JPA

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

SQL to JPA [message #735204]

Tue, 11 October 2011 07:37

Warus

Messages: 2
Registered: October 2011

Junior Member

Hi.
In my database I have a table with 3 fields: field_1, field_2, field_3 and generated entity for that table. I need to implement something like this in EclipseLink:

Select (field_1/field_3) as field_1, (field_2/field_3) as field_2, field_3 from table;

Of course this is simplified example. Is there any way to do this without NativeQuery?

thanks for any help

Report message to a moderator

Re: SQL to JPA [message #735366 is a reply to message #735204]

Tue, 11 October 2011 15:40

James Sutherland

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

Senior Member

This should work in JPQL, did you try it? You will get back an Object[] of the three values.

Select (t.field_1/t.field_3), (t.field_2/t.field_3), t.field_3 from Table t

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Previous Topic:	SQL to JPA
Next Topic:	Extensible Entities

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 17:22:37 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter