0037708: Update of Order table not working in HQL

Description

If we try to run an update query in Order table using HQL, following error is raised: java.lang.IllegalArgumentException: node to traverse cannot be null!

Steps To Reproduce

Create following HQL query:
Query updateQry = OBDal.getInstance().getSession().createQuery("update Order set description = 'a'");

You get following error:
java.lang.IllegalArgumentException: node to traverse cannot be null!

If we create the same query for Invoice table instead of Order table, query is correctly created:
Query updateQry = OBDal.getInstance().getSession().createQuery("update Invoice set description = 'a'");

It seems that Hibernate is confusing Order table name with order by keyword.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	defect	0028330		closed	reinaldoguerra	"java.lang.IllegalArgumentException: node to traverse cannot be null!" error when executing Reset Accounting
related to	defect	0028163	3.0PR15Q1	closed	reinaldoguerra	"java.lang.IllegalArgumentException: node to traverse cannot be null!" error when trying to Unpost an Order

Notes
(0102292) alostale (manager) 2018-02-09 09:27	Moving to design defect, as this seems to be a Hibernate restriction [1]. [1] https://stackoverflow.com/questions/3599803/jpa-hibernate-cant-create-entity-called-order [^]

Issue History
Date Modified	Username	Field	Change
2018-01-23 18:50	aferraz	New Issue
2018-01-23 18:50	aferraz	Assigned To	=> platform
2018-01-23 18:50	aferraz	Modules	=> Core
2018-01-23 18:50	aferraz	Triggers an Emergency Pack	=> No
2018-01-23 18:51	aferraz	Relationship added	related to 0028330
2018-01-23 18:52	aferraz	Relationship added	related to 0028163
2018-01-23 18:53	aferraz	Description Updated	View Revisions
2018-01-23 18:53	aferraz	Steps to Reproduce Updated	View Revisions
2018-01-23 18:56	aferraz	Steps to Reproduce Updated	View Revisions
2018-02-09 09:27	alostale	Note Added: 0102292
2018-02-09 09:27	alostale	Status	new => acknowledged
2018-02-09 09:27	alostale	Type	defect => design defect
2022-02-01 08:08	alostale	Assigned To	platform => Triage Platform Base