Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040428Retail ModulesStoreServerpublic2019-03-21 11:202022-05-20 09:06
Reportermtaal 
Assigned Tomtaal 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0040428: When using nativequery make sure to set the type of the parameter to handle null
DescriptionSee these topics:

[1]
https://stackoverflow.com/questions/21731343/jpa-native-query-set-null-parameter [^]

[2]
        sql = "select ad_org_id from m_product where m_product_id=:productId";
        final NativeQuery sqlQry = OBDal.getInstance().getSession().createNativeQuery(sql);
        sqlQry.setParameter("productId", getColumnValue("m_product_id", dataMetaData), StringType.INSTANCE);
        String productOrgId = (String) sqlQry.uniqueResult();
Steps To ReproduceSee description
Proposed SolutionChange should be similar to this change:
https://code.openbravo.com/erp/pmods-branches/org.openbravo.retail.storeserver.synchronization-q1/rev/686203970998 [^]
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-03-21 11:20mtaalNew Issue
2019-03-21 11:20mtaalAssigned To => mtaal
2019-03-21 11:20mtaalTriggers an Emergency Pack => No
2022-05-20 09:06mtaalStatusnew => closed

There are no notes attached to this issue.