I have a Birt project that I load my DataSource with a JNDI connection. Birt opens and closes my DB2 connection. When I stress test this report I have found that the DB2 connections are left open and my server locks up when too many of them are opened at once (40). Is there a way to manually force close my DB2 connection after my information is fetched from DB2? Thanks in advance for any advice that you may offer me.

On 10/20/2011 11:45 AM, marc.marshall wrote:
> Hi,
>
> I have a Birt project that I load my DataSource with a JNDI connection.
> Birt opens and closes my DB2 connection. When I stress test this report
> I have found that the DB2 connections are left open and my server locks
> up when too many of them are opened at once (40). Is there a way to
> manually force close my DB2 connection after my information is fetched
> from DB2? Thanks in advance for any advice that you may offer me.
>
> Thanks,
>
> Marc

Set the log level to FINEST and verify the connection is getting closed.

Jason

On 10/20/2011 12:37 PM, marc.marshall wrote:
> Jason,
>
> Does Birt close it logically or close it physically? What I mean
> logically is returning the connection to the pool. At what point Does
> Birt close the DB2 connection? Thank in advance for your advise.
>
> Thanks,
>
> Marc
>

Thanks for your suggestions. I set viewer log level to finest in my web.xml in my Birt Viewer 2.6.2. I looked in the ReportEngine logs in my Birt Viewer and did not find any open or close logs. Am I using and looking at the correct logs?