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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0018436
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] A. Platformmajorsometimes2011-09-06 08:562011-09-21 18:30
ReporteralostaleView Statuspublic 
Assigned Tomarvintm 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision4b2156ebe0da
ProjectionnoneETAnoneTarget Version2.50MP34
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.50MP24SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0018585 closedalostale Grid shows a Javascript error alert when you scroll down to the last record 
blocks defect 0018435 closedalostale 2.50 grid, cursors in Oracle are not reused 

-  Notes
(0040756)
hgbot (developer)
2011-09-06 09:43

 Repository: erp/stable/2.50
Changeset: 4b2156ebe0dade865b1286fe0e6f624d700ed8ce
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Sep 06 09:42:13 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/4b2156ebe0dade865b1286fe0e6f624d700ed8ce [^]

fixed bug 18436: 2.50 grid, cursors in Oracle are not reused
  Using prepared statement parameter for grid limits in Oracle

---
M src/org/openbravo/erpCommon/utility/TableSQLData.java
---
(0041190)
marvintm (developer)
2011-09-21 12:05

 Now when you scroll down in the grid to the lowest row, a Java exception happens and a JS alert is shown:

Missing IN or OUT parameter at index:: 9
(0041203)
marvintm (developer)
2011-09-21 18:30

 This issue was correctly fixed. The problem found is a completely different thing, explained in issue 18585. The fix done for this issue works, and resolves the performance problem described.

- Issue History
Date Modified Username Field Change
2011-09-06 08:57 alostale Type defect => backport
2011-09-06 08:57 alostale fix_in_branch => 2.50
2011-09-06 09:43 hgbot Checkin
2011-09-06 09:43 hgbot Note Added: 0040756
2011-09-06 09:43 hgbot Status scheduled => resolved
2011-09-06 09:43 hgbot Resolution open => fixed
2011-09-06 09:43 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/4b2156ebe0dade865b1286fe0e6f624d700ed8ce [^]
2011-09-21 12:05 marvintm Assigned To alostale => marvintm
2011-09-21 12:05 marvintm Note Added: 0041190
2011-09-21 12:05 marvintm Status resolved => new
2011-09-21 12:05 marvintm Resolution fixed => open
2011-09-21 18:22 marvintm Status new => scheduled
2011-09-21 18:22 marvintm fix_in_branch 2.50 => pi
2011-09-21 18:30 marvintm Relationship added related to 0018585
2011-09-21 18:30 marvintm Note Added: 0041203
2011-09-21 18:30 marvintm Status scheduled => resolved
2011-09-21 18:30 marvintm Resolution open => fixed
2011-09-21 18:30 marvintm Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker