Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Generated SQL update statement is missing columns (Why is Eclipselink not including some changed entity fields in the SQL update statement?)
Generated SQL update statement is missing columns [message #727601] Wed, 21 September 2011 11:52 Go to previous message
spockter is currently offline spockter
Messages: 8
Registered: September 2011
Junior Member
I have a case where the SQL UPDATE statement generated by EclipseLink does not include all the entity members that have changed.

I first noticed the problem with a web page where some fields were not showing changes that had been made to them.

I recreated the problem in a single EJB startup method by
- finding the entity
- detaching the entity
- change 3 entity fields (all Strings)
- merge the entity and flush
- find the entity again

In the above case, the 2nd entity shows all field changes having been made. However, if I query the DB directly or rerun the program, it is evident that one of the fields was not updated.

The EclipseLink logged SQL UPDATE is missing one of the 3 fields.

Any suggestions why this might be happening?

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic:@Embeddable Inheritance
Next Topic:Why does @OrderBy add UPPER() to the ORDER BY clause?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 23 03:04:41 EDT 2013

Powered by FUDForum. Page generated in 0.01962 seconds