Eclipse Community Forums: BIRT » close connection pool

Help

Home

Home » Archived » BIRT » close connection pool

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

close connection pool [message #367990]

Sun, 26 April 2009 21:41

mh10

Messages: 16
Registered: July 2009

Junior Member

Hi,
In Birt we use connection pool by specifying JNDI url, and after running
the report, when that opened connection object get closed

1) as it finishes execution of Sql query/ Stored Procedure
OR
2) when we close the browser

Any suggestions?

Thanks

Report message to a moderator

Re: close connection pool [message #368028 is a reply to message #367990]

Tue, 28 April 2009 14:29

Eclipse User

Originally posted by: jasonweathersby.alltel.net

It should be getting closed when the report is finished running.

Jason

mh10 wrote:
> Hi,
> In Birt we use connection pool by specifying JNDI url, and after running
> the report, when that opened connection object get closed
>
> 1) as it finishes execution of Sql query/ Stored Procedure
> OR
> 2) when we close the browser
>
>
> Any suggestions?
>
>
> Thanks
>

Report message to a moderator

Re: close connection pool [message #368089 is a reply to message #367990]

Fri, 01 May 2009 18:53

Galen Boyer

Messages: 54
Registered: July 2009

Member

mh10 wrote:

> Hi,
> In Birt we use connection pool by specifying JNDI url, and after running
> the report, when that opened connection object get closed

> 1) as it finishes execution of Sql query/ Stored Procedure
> OR
> 2) when we close the browser

> Any suggestions?

> Thanks

Just be aware that, point blank, one should not use BIRT's jndi support
because BIRT does not properly relinquish its the resources it acquires on
connections (ie, it does not close resultsets) therefore the connection
gets put back in the pool with these resources still open.

Report message to a moderator

Previous Topic:	image path in computed column
Next Topic:	SQLException catched by BIRT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 07:50:31 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter