Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0040428
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Retail Modules] StoreServermajorhave not tried2019-03-21 11:202022-05-20 09:06
ReportermtaalView Statuspublic 
Assigned Tomtaal 
PrioritynormalResolutionopenFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0040428: 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 [^]
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2019-03-21 11:20 mtaal New Issue
2019-03-21 11:20 mtaal Assigned To => mtaal
2019-03-21 11:20 mtaal Triggers an Emergency Pack => No
2022-05-20 09:06 mtaal Status new => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker