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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0041249
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 00. Application dictionarymajorhave not tried2019-07-02 16:012019-07-09 10:36
ReportershuehnerView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision61fccdd57a53
ProjectionnoneETAnoneTarget Version3.0PR19Q2.1
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tojarmendariz
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0041249: ADTreeDatasourceService.{getNodeChildenQuery,nodeHasChildren, nodeConformsToWhereClause) are not using bind-params

DescriptionThose functions are not using bind-params.


when fixing please apply new HQL-style to all 3 HQL's in the file
Steps To Reproduce-
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 00412393.0PR19Q4 closedalostale ADTreeDatasourceService.{getNodeChildenQuery,nodeHasChildren, nodeConformsToWhereClause) are not using bind-params 

-  Notes
(0113230)
hgbot (developer)
2019-07-09 09:11

Repository: erp/backports/3.0PR19Q2.1
Changeset: 697566caa6a00fd59cf9b7ab2e2235d9b60847d1
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Jul 09 09:01:57 2019 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR19Q2.1/rev/697566caa6a00fd59cf9b7ab2e2235d9b60847d1 [^]

related to issue 41249: HQL style in ADTreeDatasourceService

  Don't use StringBuilder for String concatenation
  Some other small changes

---
M modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/ADTreeDatasourceService.java
---
(0113231)
hgbot (developer)
2019-07-09 09:11

Repository: erp/backports/3.0PR19Q2.1
Changeset: 61fccdd57a5369550a076e067ce0719444f5a4ab
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Jul 09 09:10:53 2019 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR19Q2.1/rev/61fccdd57a5369550a076e067ce0719444f5a4ab [^]

fixed bug 41249: use bind parameters in ADTreeDatasourceService

  * Use parameter in query in getNodeChildrenQuery method where possible
  * Do not use deprecated OBDal.getReadableOrganizationsInClause method
  * Properly escape paremeter values in clasues coming from AD

---
M modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/ADTreeDatasourceService.java
M modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/TreeDatasourceService.java
---
(0113237)
jarmendariz (developer)
2019-07-09 10:36

Reviewed

- Issue History
Date Modified Username Field Change
2019-07-03 15:26 alostale Type defect => backport
2019-07-03 15:26 alostale Target Version => 3.0PR19Q2.1
2019-07-09 09:11 hgbot Checkin
2019-07-09 09:11 hgbot Note Added: 0113230
2019-07-09 09:11 hgbot Checkin
2019-07-09 09:11 hgbot Note Added: 0113231
2019-07-09 09:11 hgbot Status scheduled => resolved
2019-07-09 09:11 hgbot Resolution open => fixed
2019-07-09 09:11 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR19Q2.1/rev/61fccdd57a5369550a076e067ce0719444f5a4ab [^]
2019-07-09 09:11 alostale Assigned To platform => alostale
2019-07-09 09:29 alostale Review Assigned To caristu => jarmendariz
2019-07-09 10:36 jarmendariz Note Added: 0113237
2019-07-09 10:36 jarmendariz Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker