Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005509Openbravo ERP01. General setuppublic2008-10-13 10:392008-12-16 10:30
Reporterjdillet 
Assigned Togmauleon 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005509: 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
depends on backport 0005578 closed gmauleon Connection leak in SL_AlertRule_SQL.java 
Attached Filesdiff 5509.diff (1,207) 2008-10-23 18:08
https://issues.openbravo.com/file_download.php?file_id=353&type=bug
Issue History
Date ModifiedUsernameFieldChange
2008-10-13 10:39jdilletNew Issue
2008-10-13 10:39jdilletAssigned To => cromero
2008-10-13 10:39jdilletsf_bug_id0 => 2163109
2008-10-13 10:40jdilletIssue Monitored: jdillet
2008-10-20 10:47psarobeStatusnew => scheduled
2008-10-20 10:47psarobeAssigned Tocromero => gmauleon
2008-10-20 10:47psarobefix_in_branch => trunk
2008-10-23 18:08jdilletFile Added: 5509.diff
2008-10-27 17:05svnbotCheckin
2008-10-27 17:05svnbotNote Added: 0009767
2008-10-27 17:05svnbotStatusscheduled => resolved
2008-10-27 17:05svnbotResolutionopen => fixed
2008-10-27 17:05svnbotsvn_revision => 9260
2008-12-16 10:30psarobeRegression testing => No
2008-12-16 10:30psarobeStatusresolved => closed

Notes
(0009767)
svnbot   
2008-10-27 17:05   
Repository: openbravo
Revision: 9260
Author: gmauleon
Date: 2008-10-27 17:05:11 +0100 (Mon, 27 Oct 2008)

fixes 0005509 : Connection leak in SL_AlertRule_SQL.java

---
U trunk/src/org/openbravo/erpCommon/ad_callouts/SL_AlertRule_SQL.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=9260&sc=1 [^]