Openbravo Issue Tracking System - Modules
View Issue Details
0017255ModulesHuman Capital Managementpublic2011-05-18 18:402011-07-20 18:16
shuehner 
jonalegriaesarte 
normalmajorhave not tried
newopen 
5
 
 
0017255: Module probably needs update to cope with the new hibernate behavior after the library update in 3.0rc7
This file:


./org.openbravo.hcm.common/src/org/openbravo/hcm/common/ad_callout/HCMC_employee_possalcat.java: whereClause.append(" left outer join ps.salaryCategory ");

contains an explicit left join without an alias in its hql and uses the join path 'ps.salaryCategory' again later in the where clause.


The old (3.2.5) hibernate version applies the where clause to that explicit left join. The new 3.6.3 version used in/after 3.0RC7 will add another inner join and apply the where condition on that changing behavior.

Compare query behavior with old & new hibernate version.
- Add alias to the join and use the alias-name in the where condition.
- run + test all hql queries once to check result.
No tags attached.
Issue History
2011-05-18 18:40shuehnerNew Issue
2011-05-18 18:40shuehnerAssigned To => adrianromero
2011-05-18 18:41shuehnerNote Added: 0037177
2011-06-03 10:57dalsasuaAssigned Toadrianromero => dalsasua
2011-07-20 18:16dalsasuaAssigned Todalsasua => jonalegriaesarte

Notes
(0037177)
shuehner   
2011-05-18 18:41   
According to dmi: target 3.0mp0