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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0021125
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2012-07-17 16:362012-08-22 12:04
ReportermalsasuaView Statuspublic 
Assigned Tomarvintm 
PriorityurgentResolutionfixedFixed in Version3.0MP15
StatusclosedFix in branchFixed in SCM revision4cf8d54ecd9b
ProjectionnoneETAnoneTarget Version3.0MP15
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customerOBPS
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0021125: a cursor is opened and not closed when a tab is related to an auxiliar input

DescriptionIn ORACLE.
When a tab has got an auxiliar input, when you open in form mode the tab, the cursor is opened and never is closed
Steps To Reproduce. run the query:
select sum(num) from (
  SELECT SID, sql_text, COUNT(*) as num
  FROM v$open_cursor
    where upper(sql_text) like 'SELECT (CASE COUNT(*) WHEN 0 THEN 0 ELSE 1 END) AS TOTAL%');

. go to window "Sales order", to tab "line" and open in form mode

. run the query again
the result is upper than previous execution.

This tab is related to auxiliar input:
HASSECONDUOM
with SQL:
@SQL=SELECT (CASE COUNT(*) WHEN 0 THEN 0 ELSE 1 END) AS TOTAL FROM M_PRODUCT_UOM WHERE M_PRODUCT_ID=@M_Product_ID@
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0021805 closedcaristu In alert management, cursors are opened and never is closed [ORACLE] 

-  Notes
(0051458)
hgbot (developer)
2012-08-22 11:35

 Repository: erp/devel/pi
Changeset: 4cf8d54ecd9bde26433776b40ed0f5579fdd1a6e
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Aug 22 11:26:21 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/4cf8d54ecd9bde26433776b40ed0f5579fdd1a6e [^]

Fixed issue 21125. PreparedStatement wasn't being closed.

---
M modules/org.openbravo.client.application/src/org/openbravo/client/application/window/FormInitializationComponent.java
---
(0051463)
AugustoMauch (administrator)
2012-08-22 12:04

 Code reviewed and verified in pi@8a09d93b4149

- Issue History
Date Modified Username Field Change
2012-07-17 16:36 malsasua New Issue
2012-07-17 16:36 malsasua Assigned To => alostale
2012-07-17 16:36 malsasua Web browser => Google Chrome
2012-07-17 16:36 malsasua Modules => Core
2012-07-17 16:36 malsasua OBNetwork customer => Yes
2012-07-17 16:41 malsasua Web browser Google Chrome => Google Chrome
2012-07-17 16:41 malsasua Description Updated View Revisions
2012-08-10 11:08 jonalegriaesarte Web browser Google Chrome => Google Chrome
2012-08-10 11:08 jonalegriaesarte Target Version => 3.0MP15
2012-08-22 11:10 AugustoMauch Assigned To alostale => marvintm
2012-08-22 11:35 hgbot Checkin
2012-08-22 11:35 hgbot Note Added: 0051458
2012-08-22 11:35 hgbot Status new => resolved
2012-08-22 11:35 hgbot Resolution open => fixed
2012-08-22 11:35 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4cf8d54ecd9bde26433776b40ed0f5579fdd1a6e [^]
2012-08-22 12:04 AugustoMauch Closed by => AugustoMauch
2012-08-22 12:04 AugustoMauch Note Added: 0051463
2012-08-22 12:04 AugustoMauch Status resolved => closed
2012-08-22 12:04 AugustoMauch Fixed in Version => 3.0MP15
2012-10-01 10:58 malsasua Relationship added blocks 0021805

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker