0022373: Cursors are not closed when when using 349 report

Description

Cursors are not closed when when using 349 report

Steps To Reproduce

-Execute the following query at oracle:
SELECT sql_text, COUNT(*)
FROM v$open_cursor
GROUP BY sql_text
ORDER BY COUNT(*) DESC;
-Execute the 349 report
-Execute again the query:
SELECT sql_text, COUNT(*)
FROM v$open_cursor
GROUP BY sql_text
ORDER BY COUNT(*) DESC;

See that there are many open_cusors for the following statement:

SELECT C_CURRENCY_CONVERT(:1 , :2 , :3 , :4 , NULL, :5 ) FRO

Tags

Performance

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0022366

3.0MP18

closed

ioritzCia

Openbravo ERP

The multidimensional tax report does not close connection on oracle.

Notes
(0054450) hgbot (developer) 2012-11-22 10:42	Repository: erp/pmods/org.openbravo.module.aeat349.es Changeset: c9665f245aadf642157246063af721ee21757589 Author: Ioritz Cia <ioritz.cia <at> openbravo.com> Date: Thu Nov 22 10:39:10 2012 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat349.es/rev/c9665f245aadf642157246063af721ee21757589 [^] Fixes issue 22373: Cursors are not closed when using 349 report. --- M src-db/database/sourcedata/AD_MODULE.xml M src/org/openbravo/module/aeat349/es/AEAT3492010ReportDao.java M src/org/openbravo/module/aeat349/es/AEAT349ReportDao.java ---

Issue History
Date Modified	Username	Field	Change
2012-11-22 10:23	egoitz	New Issue
2012-11-22 10:23	egoitz	Assigned To	=> ioritzCia
2012-11-22 10:23	egoitz	Relationship added	related to 0022366
2012-11-22 10:42	hgbot	Checkin
2012-11-22 10:42	hgbot	Note Added: 0054450
2012-11-22 10:42	hgbot	Status	new => resolved
2012-11-22 10:42	hgbot	Resolution	open => fixed
2012-11-22 10:42	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/pmods/org.openbravo.module.aeat349.es/rev/c9665f245aadf642157246063af721ee21757589 [^]
2012-11-22 13:27	ioritzCia	Tag Attached: Performance
2013-03-04 13:07	jonalegriaesarte	Status	resolved => closed