Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020580Openbravo ERPA. Platformpublic2012-05-22 20:092012-06-25 18:33
Reporterszapata 
Assigned Tomtaal 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP13 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020580: DalBaseProcess always closes the connection
DescriptionIf you execute a DalBaseProcess (process B) from another process (process A) using the same connection, the execution of the process B closes the connection and then process A cannot use this connection anymore.
Steps To Reproduce- Create a process A
- Call a process B that extends DalBaseProcess and use the same connection (bundle)
- Try to do some database transaction using the same connection.
- See the exception.
Proposed SolutionSee diff file attached
Additional Information
TagsNo tags attached.
Relationships
related to defect 0027878 closed marvintm Code in DalConnectionprovider relate to getTransactionConnection seems to leak db connections always 
related to defect 00299023.0PR15Q3 closed alostale ProcessBundle.setCloseConnection(false) has no impact when using DalBaseProcess, the connection is always closed 
Attached Filesdiff SAIC_ProcessBundle_close_connection.diff (2,402) 2012-05-22 20:09
https://issues.openbravo.com/file_download.php?file_id=5255&type=bug
Issue History
Date ModifiedUsernameFieldChange
2012-05-22 20:09szapataNew Issue
2012-05-22 20:09szapataAssigned To => mtaal
2012-05-22 20:09szapataFile Added: SAIC_ProcessBundle_close_connection.diff
2012-05-22 20:09szapataWeb browser => Google Chrome
2012-05-22 20:09szapataModules => Core
2012-05-22 20:09szapataOBNetwork customer => Yes
2012-05-28 09:57alostaleWeb browserGoogle Chrome => Google Chrome
2012-05-28 09:57alostaleTypedefect => design defect
2012-05-31 20:26szapataIssue Monitored: szapata
2012-06-01 21:35networkbWeb browserGoogle Chrome => Google Chrome
2012-06-01 21:36networkbIssue Monitored: networkb
2012-06-07 17:18hgbotCheckin
2012-06-07 17:18hgbotNote Added: 0049681
2012-06-07 17:18hgbotStatusnew => resolved
2012-06-07 17:18hgbotResolutionopen => fixed
2012-06-07 17:18hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2a2e526a1da576f96b6778e55b14b77605fa360f [^]
2012-06-25 18:33AugustoMauchNote Added: 0050073
2012-06-25 18:33AugustoMauchStatusresolved => closed
2012-06-25 18:33AugustoMauchFixed in Version => 3.0MP13
2015-05-15 13:11alostaleRelationship addedrelated to 0027878
2015-05-21 09:24alostaleRelationship addedrelated to 0029902

Notes
(0049681)
hgbot   
2012-06-07 17:18   
Repository: erp/devel/pi
Changeset: 2a2e526a1da576f96b6778e55b14b77605fa360f
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Thu Jun 07 17:17:34 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/2a2e526a1da576f96b6778e55b14b77605fa360f [^]

Fixes issue 20580: DalBaseProcess always closes the connection
Close connection can be controlled explicitly

---
M src/org/openbravo/scheduling/ProcessBundle.java
M src/org/openbravo/service/db/DalBaseProcess.java
---
(0050073)
AugustoMauch   
2012-06-25 18:33   
Code reviewed and verified in pi@bd848324099c