Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039040Retail ModulesWeb POSpublic2018-07-25 11:112018-07-26 16:10
Reportercaristu 
Assigned Tocaristu 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR18Q4 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Support ticket
Regression levelPre packaging ( pi )
Regression date2018-07-24
Regression introduced in release
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/95dcfa93d706654e1fbddfc3966bec7280081ac1 [^]
Triggers an Emergency PackNo
Summary0039040: ProcessHQLQuery is not handling properly queries without alias after Hibernate upgrade
DescriptionProcessHQLQuery is not handling properly queries without alias after Hibernate upgrade.

After the Hibernate upgrade, the query.getReturnAlias() method returns null for each selected column in the query which does not have an alias. Before the upgrade, this method was returning the position of the column if the alias was null.

This behavior causes failure in the JSONRowConverter class, which due to this change is trying to put null keys in the JSON result, causing errors.
Steps To Reproduce1) Install the french certification module
2) Try to log-in in the WebPOS
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
caused by feature request 0037064 closed caristu Openbravo ERP upgrade hibernate to 5.3.2 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-07-25 11:11caristuNew Issue
2018-07-25 11:11caristuAssigned To => Retail
2018-07-25 11:11caristuTriggers an Emergency Pack => No
2018-07-25 11:11caristuAssigned ToRetail => caristu
2018-07-25 11:12caristuRelationship addedcaused by 0037064
2018-07-25 11:27hgbotCheckin
2018-07-25 11:27hgbotNote Added: 0105937
2018-07-25 11:27hgbotStatusnew => resolved
2018-07-25 11:27hgbotResolutionopen => fixed
2018-07-25 11:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/a5886da3bbba3ab5838f85631c4fc163cf9610d6 [^]
2018-07-25 11:27caristuReview Assigned To => marvintm
2018-07-25 11:28caristuRegression level => Pre packaging ( pi )
2018-07-25 11:28caristuRegression date => 2018-07-24
2018-07-25 11:28caristuRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/95dcfa93d706654e1fbddfc3966bec7280081ac1 [^]
2018-07-26 16:10marvintmStatusresolved => closed
2018-07-26 16:10marvintmFixed in Version => RR18Q4

Notes
(0105937)
hgbot   
2018-07-25 11:27   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: a5886da3bbba3ab5838f85631c4fc163cf9610d6
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Wed Jul 25 11:27:05 2018 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/a5886da3bbba3ab5838f85631c4fc163cf9610d6 [^]

fixes bug 39040: ProcessHQLQuery is not handling properly queries without alias

---
M src/org/openbravo/mobile/core/process/ProcessHQLQuery.java
---