Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040682Openbravo ERP09. Financial managementpublic2019-04-04 13:272019-04-25 16:54
Reporteralostale 
Assigned Tononofrancisco 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR19Q1.1Fixed in Version3.0PR19Q1.1 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0040682: use bind-parameters in FIN_BankStatementImport
DescriptionFIN_BankStatementImport.matchBusinessPartnerByNameTokens method is generating a sql setting parameters by String concatenation, replace tokens by bind parameters.
Steps To Reproduce-
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0040522 closed nonofrancisco use bind-parameters in FIN_BankStatementImport 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-04-25 13:20SandrahuguetTypedefect => backport
2019-04-25 13:20SandrahuguetTarget Version => 3.0PR19Q1.1
2019-04-25 16:45hgbotCheckin
2019-04-25 16:45hgbotNote Added: 0111323
2019-04-25 16:45hgbotStatusscheduled => resolved
2019-04-25 16:45hgbotResolutionopen => fixed
2019-04-25 16:45hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/a5d02171e10c523cfac9da2c54e6fb29ee292514 [^] => http://code.openbravo.com/erp/backports/3.0PR19Q1.1/rev/04e077fb1d4c68d5023019b8029a6696820bbb65 [^]
2019-04-25 16:45hgbotCheckin
2019-04-25 16:45hgbotNote Added: 0111324
2019-04-25 16:54SandrahuguetReview Assigned To => Sandrahuguet
2019-04-25 16:54SandrahuguetNote Added: 0111326
2019-04-25 16:54SandrahuguetStatusresolved => closed
2019-04-25 16:54SandrahuguetFixed in Version => 3.0PR19Q1.1

Notes
(0111323)
hgbot   
2019-04-25 16:45   
Repository: erp/backports/3.0PR19Q1.1
Changeset: 04e077fb1d4c68d5023019b8029a6696820bbb65
Author: Nono Carballo <nonofce <at> gmail.com>
Date: Thu Apr 25 12:39:23 2019 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR19Q1.1/rev/04e077fb1d4c68d5023019b8029a6696820bbb65 [^]

Fixes issue 40682: Prevents use of string concatenation in query

Query to get business partners was formed using string concatenation.
This fix replaces the string concatenation by bind parameters in query.

---
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/utility/FIN_BankStatementImport.java
---
(0111324)
hgbot   
2019-04-25 16:45   
Repository: erp/backports/3.0PR19Q1.1
Changeset: bbf97c4e9834124a4c16b0872cc4573f90ad8457
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Thu Apr 25 13:12:34 2019 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR19Q1.1/rev/bbf97c4e9834124a4c16b0872cc4573f90ad8457 [^]

related to issue 40682 code review changes

---
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/utility/FIN_BankStatementImport.java
---
(0111326)
Sandrahuguet   
2019-04-25 16:54   
Code review + testing OK