Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027591Openbravo ERPA. Platformpublic2014-09-11 18:552014-09-18 06:12
ReporterAugustoMauch 
Assigned ToAugustoMauch 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR14Q4Fixed in Version3.0PR14Q4 
Merge Request Status
Review Assigned Toshankarb
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027591: It is not possible to use Collection parameters in HQL tables
DescriptionIn the HQLDataSourceService.getQuery method, the named parameters are set to the Query. The problem was that only the query.setParameter method is used for this, and this method does not allow collection parameters.

If the named parameter is a collection, query.setParameterList should be used.
Steps To ReproduceIn this repo: https://code.openbravo.com/erp/devel/pi-reconref/ [^]

- Open Sales Invoice
- Pick a record with Total Outstanding > 0
- Open the Add Payment process. An exception will be thrown
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 00275783.0PR15Q1 closed AugustoMauch HQL datasources problem when using list parameters 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-09-11 18:55AugustoMauchNew Issue
2014-09-11 18:55AugustoMauchAssigned To => AugustoMauch
2014-09-11 18:55AugustoMauchOBNetwork customer => No
2014-09-11 18:55AugustoMauchModules => Core
2014-09-11 18:55AugustoMauchTriggers an Emergency Pack => No
2014-09-11 18:56AugustoMauchIssue Monitored: shankarb
2014-09-11 18:56AugustoMauchReview Assigned To => shankarb
2014-09-11 18:57hgbotCheckin
2014-09-11 18:57hgbotNote Added: 0070088
2014-09-11 18:57hgbotStatusnew => resolved
2014-09-11 18:57hgbotResolutionopen => fixed
2014-09-11 18:57hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/02a1e1a17c3bf16cec1d3c3c3524b126982636e6 [^]
2014-09-12 16:39hudsonbotCheckin
2014-09-12 16:39hudsonbotNote Added: 0070106
2014-09-18 06:12shankarbNote Added: 0070189
2014-09-18 06:12shankarbStatusresolved => closed
2014-09-18 06:12shankarbFixed in Version => 3.0PR14Q4
2014-11-27 10:45AugustoMauchRelationship addedhas duplicate 0027578

Notes
(0070088)
hgbot   
2014-09-11 18:57   
Repository: erp/devel/pi
Changeset: 02a1e1a17c3bf16cec1d3c3c3524b126982636e6
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Thu Sep 11 18:56:37 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/02a1e1a17c3bf16cec1d3c3c3524b126982636e6 [^]

Fixes issue 27591: It is not possible to use Collection params in HQL tables

If the named parameter is a collection, query.setParameterList is used to add the parameter to the query. If not, query.setParameter is used.

---
M modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/HQLDataSourceService.java
---
(0070106)
hudsonbot   
2014-09-12 16:39   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/5c9f936cfa1d [^]
Maturity status: Test
(0070189)
shankarb   
2014-09-18 06:12   
Code reviewed and verified in pi changeset 04ae35aa72e5.