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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0027591
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2014-09-11 18:552014-09-18 06:12
ReporterAugustoMauchView Statuspublic 
Assigned ToAugustoMauch 
PrioritynormalResolutionfixedFixed in Version3.0PR14Q4
StatusclosedFix in branchFixed in SCM revision02a1e1a17c3b
ProjectionnoneETAnoneTarget Version3.0PR14Q4
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toshankarb
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0027591: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
has duplicate defect 00275783.0PR15Q1 closedAugustoMauch HQL datasources problem when using list parameters 

-  Notes
(0070088)
hgbot (developer)
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 (developer)
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 (reporter)
2014-09-18 06:12

 Code reviewed and verified in pi changeset 04ae35aa72e5.

- Issue History
Date Modified Username Field Change
2014-09-11 18:55 AugustoMauch New Issue
2014-09-11 18:55 AugustoMauch Assigned To => AugustoMauch
2014-09-11 18:55 AugustoMauch Modules => Core
2014-09-11 18:55 AugustoMauch Triggers an Emergency Pack => No
2014-09-11 18:56 AugustoMauch Issue Monitored: shankarb
2014-09-11 18:56 AugustoMauch Review Assigned To => shankarb
2014-09-11 18:57 hgbot Checkin
2014-09-11 18:57 hgbot Note Added: 0070088
2014-09-11 18:57 hgbot Status new => resolved
2014-09-11 18:57 hgbot Resolution open => fixed
2014-09-11 18:57 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/02a1e1a17c3bf16cec1d3c3c3524b126982636e6 [^]
2014-09-12 16:39 hudsonbot Checkin
2014-09-12 16:39 hudsonbot Note Added: 0070106
2014-09-18 06:12 shankarb Note Added: 0070189
2014-09-18 06:12 shankarb Status resolved => closed
2014-09-18 06:12 shankarb Fixed in Version => 3.0PR14Q4
2014-11-27 10:45 AugustoMauch Relationship added has duplicate 0027578

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker