Eclipse Community Forums: BIRT » Connections to Informix DB are not reused (and not closed)

Help

Home

Home » Eclipse Projects » BIRT » Connections to Informix DB are not reused (and not closed)

Show: Today's Messages :: Show Polls :: Message Navigator

Connections to Informix DB are not reused (and not closed) [message #723046]

Wed, 07 September 2011 10:00

meltie
Messages: 4
Registered: September 2011

Junior Member

Hi,

we use BIRT designer 2.6.1 to create our reports and deploy them to our JBoss 4.2.3.GA application server running our application and BIRT engine 3.7.

We have a complex report that needs to make a lot of queries (more than 50). When running this report on a MySQL DB, all queries use the same database connection. When running the report on an Informix DB, a new database connection is created for every query. After executing the queries the connections are not closed. Another report will reuse the open connections, but the connections are not reused from within the same report.

This behaviour is the same for both DB connections using URL and username/password and using JNDI.

I would like BIRT to reuse the existing database connections on Informix DB as it does on MySQL DB. Do you have an idea what causes this behaviour and how it can be fixed?

Thanks in advance for your replies!

Regards,

meltie

Report message to a moderator

Re: Connections to Informix DB are not reused (and not closed) [message #723585 is a reply to message #723046]

Thu, 08 September 2011 17:26

Michael Williams
Messages: 828
Registered: July 2009

Senior Member

Hi meltie,

So, when you use Informix you get a new connection for each dataSet whereas when you use MySQL, you don't? In both cases you're using a single dataSource? Is there any layout differences or is it the same report that is different for the two scenarios?

Regards,

Michael

http://www.birt-exchange.org

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

Re: Connections to Informix DB are not reused (and not closed) [message #723691 is a reply to message #723585]

Fri, 09 September 2011 03:47

meltie
Messages: 4
Registered: September 2011

Junior Member

Hi Michael,

thanks for your reply. It is the exact same report.

In the report there is one datasource and six datasets. The datasets are each used several times within the report with different filters (the complexity of the report made it hard to do all the required filtering within the query). If a dataset is reused within a report, the database is queried once for each use, which is AFAIK normal BIRT behaviour. But on MySQL, only one connection is created and reused for all these queries, while on Informix, a seperate connection is created for each query.

Do you have any idea what causes this behaviour?

Thanks and regards,

meltie

Report message to a moderator

Re: Connections to Informix DB are not reused (and not closed) [message #723787 is a reply to message #723691]

Fri, 09 September 2011 09:40

Michael Williams
Messages: 828
Registered: July 2009

Senior Member

I have not heard of this issue before. Let me ask around and see if anyone else has. I did a quick web search with no luck. I'll let you know.

Regards,

Michael

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

Re: Connections to Informix DB are not reused (and not closed) [message #724472 is a reply to message #723787]

Mon, 12 September 2011 08:43

meltie
Messages: 4
Registered: September 2011

Junior Member

Thank you very much, Michael. I found nothing on the web either.

Report message to a moderator

Re: Connections to Informix DB are not reused (and not closed) [message #724555 is a reply to message #724472]

Mon, 12 September 2011 10:00

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

You may need to open a bugzilla entry for this. Are you using standard
jdbc connection in BIRT or connection profile? Are you sure JNDI is setup.

Jason

On 9/12/2011 8:43 AM, meltie wrote:
> Thank you very much, Michael. I found nothing on the web either.

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Connections to Informix DB are not reused (and not closed) [message #724835 is a reply to message #724555]

Tue, 13 September 2011 06:19

meltie
Messages: 4
Registered: September 2011

Junior Member

Hi Jason,

thanks for your reply.

As I wrote above, the behaviour is the same for both JNDI and standard JDBC connections. I am sure I used JNDI because I tested this and used a datasource configuration that only had the JNDI URL and no other connection data (to make sure there would be no fallback to JDBC connection), and vice versa for JDBC connections. I did numerous test with different datasource configurations and JNDI datasource options and the behaviour was always the same on Informix. I also tried different database drivers and such, with always the same result.

Regards,

meltie

[Updated on: Tue, 13 September 2011 06:22]

Report message to a moderator

Re: Connections to Informix DB are not reused (and not closed) [message #725025 is a reply to message #724835]

Tue, 13 September 2011 14:13

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

Can you open a bugzilla entry for this?

Jason

On 9/13/2011 6:19 AM, meltie wrote:
> Hi Jason,
>
> thanks for your reply.
> As I wrote above, the behaviour is the same for both JNDI and standard
> JDBC connections. I am sure I used JNDI because I tested this and used a
> datasource configuration that only had the JNDI URL and no other
> connection data (to make sure there would be no fallback to JDBC
> connection). I did numerous test with different datasource
> configurations and JNDI datasource options and the behaviour was always
> the same on Informix.
> Regards,
>
> meltie

Jason Weathersby

BIRT Exchange

Report message to a moderator

Previous Topic:	REST Web Services
Next Topic:	Can I use Eclipse BIRT for SugarCRM?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 26 03:32:31 EDT 2013