Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

problem with @FieldResult, mapping does not seem to work

 
niels maes
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi everyone,

I'm trying to execute the following query:

I expect an id and a lastname to be returned from the query, However only an id is returned.
It seems that the fieldresult annotation does not work.
If I use a different query: select id, lastname from employee, I get the lastname returned.
Below is the complete entity.

Does anyone have an idea what could be wrong?
thanks.
 
Vijitha Kumara
Bartender
Posts: 3914
9
Chrome Fedora Hibernate
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to the CodeRanch!

Why you haven't mapped the "lastName" column in the entity as with the "firstName" in the first place?
 
niels maes
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks.

It is just an example to try out the @field_result annotation.
I'm trying out all annotations, originally the mapping was as in your suggestion.
I deliberately changed the mapping/the query to be able to test the field_result annotation.
But I don't understand why it doesn't work.
 
Vijitha Kumara
Bartender
Posts: 3914
9
Chrome Fedora Hibernate
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I haven't tried this myself (may be later I'll try). But I think persistence provider has no idea of the field being a persistent field. You can verify this perhaps by persisting an entity of this with this code?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic