Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 338693 - BIRT leaves behind db2fmp.exe for DB2 data source
Summary: BIRT leaves behind db2fmp.exe for DB2 data source
Status: RESOLVED WORKSFORME
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: 2.6.1   Edit
Hardware: PC Windows XP
: P3 normal (vote)
Target Milestone: 3.7.0   Edit
Assignee: Birt-ReportDesigner CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-02 10:54 EST by NL CLA
Modified: 2011-05-26 13:32 EDT (History)
2 users (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description NL CLA 2011-03-02 10:54:03 EST 
I'm using BIRT with DB2 as my data source on Windows. While I was playing with data set, I noticed many db2fmp.exe processes being left behind. db2fmp is used by DB2 to run external routines. It looks like BIRT is not closing or cleaning up database connections properly.

Also, when I'm running the report that accesses the database, the mouse pointer constantly flickers between the normal select and busy icons.  This seems to be related to opening and closing connections as well.  

BIRT version:
Business Intelligence and Reporting Tools

Version: 2.6.1.v20100709a-9iF7A8FGLY4z0pxX3ORrsdrp6JXb
Build id: v20100915-1750
Comment 1 Xiaoying Gu CLA 2011-03-07 03:33:32 EST 
Hi,

I can not reproduce this issue with the BIRT 2.6.1 designer.

My steps:
1. Create a dataset using db2 datasource in the 2.6.1 report designer.
2. Do some db related operation, including: 
 a) dataset preview
 b) drag the dataset to layout and preview reports.
 c) create parameters using the db2 dataset and preview reports

I did not found the db2fmp.exe process in my taskmgr.
Comment 2 NL CLA 2011-03-07 11:01:31 EST 
I noticed the problem occurs with JDBC Database Connection for Query Builder.  It doesn't happen with JDBC Data Source.  

Your steps are correct to reproduce the leaking connection.  I see around two db2fmp.exe created after previewing the reports each time.
Comment 3 Xiaoying Gu CLA 2011-03-09 00:46:29 EST 
(In reply to comment #2)
> I noticed the problem occurs with JDBC Database Connection for Query Builder. 
> It doesn't happen with JDBC Data Source.  
> 
> Your steps are correct to reproduce the leaking connection.  I see around two
> db2fmp.exe created after previewing the reports each time.
Comment 4 Xiaoying Gu CLA 2011-03-09 00:49:26 EST 
(In reply to comment #2)
> I noticed the problem occurs with JDBC Database Connection for Query Builder. 
> It doesn't happen with JDBC Data Source.  
> 
> Your steps are correct to reproduce the leaking connection.  I see around two
> db2fmp.exe created after previewing the reports each time.

I tried creating a datasource using JDBC Database Connection for Query Builder, but still can not reproduce this issue. There is no db2fmp.exe detected in the taskmgr. I was using the 2.6.1 release.
Comment 5 Xiaoying Gu CLA 2011-03-15 22:06:41 EDT 
Can not reproduce on windows xp + 2.6.1 release + jdk 1.6 + sql query builder.
DB2 driver: com.ibm.db2.jcc.DB2Driver, (db2jcc.jar)

Set as worksforme.