Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0040428 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
design defect | [Retail Modules] StoreServer | major | have not tried | 2019-03-21 11:20 | 2022-05-20 09:06 | |||
Reporter | mtaal | View Status | public | |||||
Assigned To | mtaal | |||||||
Priority | normal | Resolution | open | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Review Assigned To | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0040428: When using nativequery make sure to set the type of the parameter to handle null | |||||||
Description | See 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 Reproduce | See description | |||||||
Proposed Solution | Change should be similar to this change: https://code.openbravo.com/erp/pmods-branches/org.openbravo.retail.storeserver.synchronization-q1/rev/686203970998 [^] | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
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 |