Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005578Openbravo ERP01. General setuppublic2008-10-20 10:472008-12-10 21:08
Reporterjdillet 
Assigned Togmauleon 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
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
Summary0005578: Connection leak in SL_AlertRule_SQL.java
DescriptionConnection, statement and resultset used in SL_AlertRule_SQL.java are never closed.
Steps To ReproduceGeneral Setup > Application > Alert > Create a new Record > Fill field SQL with:
- a query without error
- a query with errors: SELXT XXX FROM DUAL

In both cases, connection created in this.getPreparedStatement(strSQL) is never released
Proposed SolutionRelease Connection, statement and resultset in a finally block.

See:
- branch teseo: revision 8597
- branch holding: revision 8596
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0005509 closed gmauleon Connection leak in SL_AlertRule_SQL.java 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-10-20 10:47psarobeNew Issue
2008-10-20 10:47psarobeAssigned To => gmauleon
2008-10-20 10:47psarobeStatusnew => scheduled
2008-10-27 17:06svnbotCheckin
2008-10-27 17:06svnbotNote Added: 0009768
2008-10-27 17:06svnbotStatusscheduled => resolved
2008-10-27 17:06svnbotResolutionopen => fixed
2008-10-27 17:06svnbotsvn_revision => 9261
2008-10-27 21:46svnbotCheckin
2008-10-27 21:46svnbotNote Added: 0009774
2008-10-27 21:46svnbotsvn_revision9261 => 9275
2008-12-10 21:08psarobeRegression testing => No
2008-12-10 21:08psarobeStatusresolved => closed
2008-12-10 21:08psarobeNote Added: 0011163

Notes
(0009768)
svnbot   
2008-10-27 17:06   
Repository: openbravo
Revision: 9261
Author: gmauleon
Date: 2008-10-27 17:06:41 +0100 (Mon, 27 Oct 2008)

fixes 0005578 : Connection leak in SL_AlertRule_SQL.java

---
U branches/r2.40/src/org/openbravo/erpCommon/ad_callouts/SL_AlertRule_SQL.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=9261&sc=1 [^]
(0009774)
svnbot   
2008-10-27 21:46   
Repository: openbravo
Revision: 9275
Author: villind
Date: 2008-10-27 21:46:36 +0100 (Mon, 27 Oct 2008)

Merged change 9261. fixes 0005578 : Connection leak in SL_AlertRule_SQL.java

---
_U branches/bonware/r2.40/
_U branches/bonware/r2.40/config/setup-tool/
_U branches/bonware/r2.40/eclipse.install.source.launch
_U branches/bonware/r2.40/export.database.launch
U branches/bonware/r2.40/src/org/openbravo/erpCommon/ad_callouts/SL_AlertRule_SQL.java
_U branches/bonware/r2.40/src-core/src/org/openbravo/database/OpenbravoDriverManagerConnectionFactory.java
_U branches/bonware/r2.40/update.database.launch
---

https://dev.openbravo.com/websvn/openbravo/?rev=9275&sc=1 [^]
(0011163)
psarobe   
2008-12-10 21:08   
can't able to verify