Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018435Openbravo ERPA. Platformpublic2011-09-06 08:562012-04-02 06:11
Reporteralostale 
Assigned Toalostale 
PriorityurgentSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP2.2 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018435: 2.50 grid, cursors in Oracle are not reused
DescriptionIn 2.50 grid using Oracle as DB, the generated SQL includes in the query string the pagination paramenters instead of being prepared statement paremeters. This causes many different cursors creation each time scroll is done in any grid making thus them not reusable.
Steps To ReproduceHaving a big amount of records and in a complex tab first time data is requested the query is slow. If the cursor is properly reused next time, the query should be faster.
Proposed SolutionPartially rollback issue 0009641 for the Oracle query generation.
Additional Information
TagsnextMP
Relationships
depends on backport 00184362.50MP34 closed marvintm 2.50 grid, cursors in Oracle are not reused 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-09-06 08:56alostaleNew Issue
2011-09-06 08:56alostaleAssigned To => alostale
2011-09-06 08:56alostaleModules => Core
2011-09-06 08:57alostaleStatusnew => scheduled
2011-09-06 08:57alostalefix_in_branch => pi
2011-09-19 11:12jonalegriaesarteversion2.50MP24 => 3.0MP2.2
2011-09-19 11:12jonalegriaesarteTarget Version2.50MP34 => 3.0MP5
2011-09-19 11:12jonalegriaesartefix_in_branchpi =>
2011-10-31 14:28alostaleTarget Version3.0MP5 => 3.0MP6
2011-11-15 08:41alostaleTag Attached: nextMP
2011-11-15 08:59alostaleTarget Version3.0MP6 =>
2012-03-23 12:28hgbotCheckin
2012-03-23 12:28hgbotNote Added: 0046680
2012-03-23 12:28hgbotStatusscheduled => resolved
2012-03-23 12:28hgbotResolutionopen => fixed
2012-03-23 12:28hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/15fb670544fb700f44e15791567a6e8d50257ca2 [^]
2012-03-23 15:47marvintmStatusresolved => closed
2012-04-02 06:11hudsonbotCheckin
2012-04-02 06:11hudsonbotNote Added: 0047210

Notes
(0046680)
hgbot   
2012-03-23 12:28   
Repository: erp/devel/pi
Changeset: 15fb670544fb700f44e15791567a6e8d50257ca2
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri Mar 23 12:27:51 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/15fb670544fb700f44e15791567a6e8d50257ca2 [^]

fixed bug 18435: 2.50 grid, cursors in Oracle are not reused

Applied 2.50 patch for issue 0018436

---
M src/org/openbravo/erpCommon/utility/TableSQLData.java
---
(0047210)
hudsonbot   
2012-04-02 06:11   
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/7814864461ac [^]

Maturity status: Test