Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0018435 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | sometimes | 2011-09-06 08:56 | 2012-04-02 06:11 | |||
| Reporter | alostale | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 15fb670544fb | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 3.0MP2.2 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0018435: 2.50 grid, cursors in Oracle are not reused | |||||||
| Description | In 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 Reproduce | Having 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 Solution | Partially rollback issue 0009641 for the Oracle query generation. | |||||||
| Tags | nextMP | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0046680) hgbot (developer) 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 (developer) 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 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-09-06 08:56 | alostale | New Issue | |
| 2011-09-06 08:56 | alostale | Assigned To | => alostale |
| 2011-09-06 08:56 | alostale | Modules | => Core |
| 2011-09-06 08:57 | alostale | Status | new => scheduled |
| 2011-09-06 08:57 | alostale | fix_in_branch | => pi |
| 2011-09-19 11:12 | jonalegriaesarte | version | 2.50MP24 => 3.0MP2.2 |
| 2011-09-19 11:12 | jonalegriaesarte | Target Version | 2.50MP34 => 3.0MP5 |
| 2011-09-19 11:12 | jonalegriaesarte | fix_in_branch | pi => |
| 2011-10-31 14:28 | alostale | Target Version | 3.0MP5 => 3.0MP6 |
| 2011-11-15 08:41 | alostale | Tag Attached: nextMP | |
| 2011-11-15 08:59 | alostale | Target Version | 3.0MP6 => |
| 2012-03-23 12:28 | hgbot | Checkin | |
| 2012-03-23 12:28 | hgbot | Note Added: 0046680 | |
| 2012-03-23 12:28 | hgbot | Status | scheduled => resolved |
| 2012-03-23 12:28 | hgbot | Resolution | open => fixed |
| 2012-03-23 12:28 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/15fb670544fb700f44e15791567a6e8d50257ca2 [^] |
| 2012-03-23 15:47 | marvintm | Status | resolved => closed |
| 2012-04-02 06:11 | hudsonbot | Checkin | |
| 2012-04-02 06:11 | hudsonbot | Note Added: 0047210 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |