Connections doesn't closes.[Using .rptlibrary]

View: New views
4 Messages — Rating Filter:   Alert me  

Connections doesn't closes.[Using .rptlibrary]

by tonismar bernardo-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

I've been monitoring BIRT connections with PostgreSQL and sometimes it doesn't closes.
I read it's seems that when .rptlibrary and .rptdesign files have a datasource. Causing two connections with the database.
I take off the datasource from my .rptdesign file but, using only the datasource from the .rptlibrary, the problem still happen.
Any ideas about this?

thanks!

Tonismar
http://kroiner.wordpress.com

_______________________________________________
birt-report-engine-dev mailing list
birt-report-engine-dev@...
https://dev.eclipse.org/mailman/listinfo/birt-report-engine-dev

RE: Connections doesn't closes.[Using.rptlibrary]

by portal on behalf of Gary Xue :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi Tonismar,

I’ve not been able to reproduce this issue with combinations of data sources from library and report. To help us look into this further, can you open a Bugzilla with more information on how to reproduce this issue? If will be helpful if you can attach to Bugzilla a sample report that’s giving you the connection leak.

 

Thanks,

Gary

 

 

From: birt-report-engine-dev-bounces@... [mailto:birt-report-engine-dev-bounces@...] On Behalf Of tonismar bernardo
Sent: Wednesday, September 02, 2009 8:02 AM
To: birt-report-engine-dev@...
Subject: [birt-report-engine-dev] Connections doesn't closes.[Using.rptlibrary]

 

Hi,

I've been monitoring BIRT connections with PostgreSQL and sometimes it doesn't closes.
I read it's seems that when .rptlibrary and .rptdesign files have a datasource. Causing two connections with the database.
I take off the datasource from my .rptdesign file but, using only the datasource from the .rptlibrary, the problem still happen.
Any ideas about this?

thanks!

Tonismar
http://kroiner.wordpress.com


_______________________________________________
birt-report-engine-dev mailing list
birt-report-engine-dev@...
https://dev.eclipse.org/mailman/listinfo/birt-report-engine-dev

Re: Connections doesn't closes.[Using.rptlibrary]

by tonismar bernardo-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Gary,

Thanks for attention. I created the Bug 288646.
Take a look.

[]'s
Tonismar
http://kroiner.wordpress.com


On Thu, Sep 3, 2009 at 6:09 PM, Gary Xue <gxue@...> wrote:

Hi Tonismar,

I’ve not been able to reproduce this issue with combinations of data sources from library and report. To help us look into this further, can you open a Bugzilla with more information on how to reproduce this issue? If will be helpful if you can attach to Bugzilla a sample report that’s giving you the connection leak.

 

Thanks,

Gary

 

 

From: birt-report-engine-dev-bounces@... [mailto:birt-report-engine-dev-bounces@...] On Behalf Of tonismar bernardo
Sent: Wednesday, September 02, 2009 8:02 AM
To: birt-report-engine-dev@...
Subject: [birt-report-engine-dev] Connections doesn't closes.[Using.rptlibrary]

 

Hi,

I've been monitoring BIRT connections with PostgreSQL and sometimes it doesn't closes.
I read it's seems that when .rptlibrary and .rptdesign files have a datasource. Causing two connections with the database.
I take off the datasource from my .rptdesign file but, using only the datasource from the .rptlibrary, the problem still happen.
Any ideas about this?

thanks!

Tonismar
http://kroiner.wordpress.com


_______________________________________________
birt-report-engine-dev mailing list
birt-report-engine-dev@...
https://dev.eclipse.org/mailman/listinfo/birt-report-engine-dev



_______________________________________________
birt-report-engine-dev mailing list
birt-report-engine-dev@...
https://dev.eclipse.org/mailman/listinfo/birt-report-engine-dev

Re: Connections doesn't closes.[Using .rptlibrary]

by Galen Boyer :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

You are correct in that a connection being present in library and also in design file means 2 connections are spawned.  If you check what is happening on those connections, the library needs are from the library and the design needs from the design file.

Now, on the single one not closing, I found that when there is an error in execution, BIRT does not close the connection.  I also remember that were I to click cancel during execution that process does not stop but BIRT does end up closing the connection.  However, if I clicked cancel and then retried, then one of those 2 connections would not be closed.

Those were my observations of closing connections.

The connection remaining open after error was very reproducible.

tonismar bernardo-2 wrote:
Hi,

I've been monitoring BIRT connections with PostgreSQL and sometimes it
doesn't closes.
I read it's seems that when .rptlibrary and .rptdesign files have a
datasource. Causing two connections with the database.
I take off the datasource from my .rptdesign file but, using only the
datasource from the .rptlibrary, the problem still happen.
Any ideas about this?

thanks!

Tonismar
http://kroiner.wordpress.com

_______________________________________________
birt-report-engine-dev mailing list
birt-report-engine-dev@eclipse.org
https://dev.eclipse.org/mailman/listinfo/birt-report-engine-dev