Database connection pool issue

[bobz28]

Hi,

I am new to Jasper Report and currently run into an issue with connection pool, can someone help me to strait this up?

 

Well, I am integrating Jasper Report with Spring framework, and the database connection pool is managed by WebLogic Server. After a while testing the app I am running out of the connection (Connection pool is set to 15). It doesn't seem that once the report is created, connection get release and put it back to the pool. I followed the instruction in the book "Jasper report for Java Developer".

Please help.

Thanks,

[bobz28]

Does any body know, if we have any way to work around this issue? Thanks-

[bobz28]

I think this is a connection leak, I can bring the connection pool up to 50 or 150 and the 'Connection time out' attribute ...etc. But this is not a robust way. Does anyone know a better way to handle this issue?

Thanks in advance.

Bob

[Teodor Danciu]

Hi,

 

I did not see any piece of code from you and I have not read that book.

All I can tell you is that when you pass a connection to JasperReports, you should take care of puttin it back in the pool (by closing it?), as JasperReports does not do that.

Since it was not JasperReports who created the connection, it is not JasperReports who should close it.

The best thing to do would be to contact the author of the book to get the proper explanations for the sample code you use.

 

Thank you,

Teodor