Not closed SQL statements

By: Piotr Walczyszyn - pedrow
Not closed SQL statements
2003-10-24 08:24
Is there a way to force Jasper to close SQL statements after report is generated?

By: Peter Lamprecht - lampocello
RE: Not closed SQL statements
2003-11-20 00:15
Hi Piotr,

I think we do have a similar problem, but I am not sure, so I opened a new thread. (see: Warning statement left open).

Did you already solve your problem?
Do you have a good tip?

Thanks in advance,

By: Teodor Danciu - teodord
RE: Not closed SQL statements
2003-11-28 14:11


JasperReports open an SQL statement of its own only
if a query string is provided and a Connection object.
If it creates this statement, it also closes it
after the report filling process ends.

However, I have to admit that this portion of
JasperReports needs a little refactoring as it is possible for the statements to remain open in
certain cases.

I'll do this refactoring for the next version and I hope
it will solve your problems.

Thank you,
2002 JI Open Discussion's picture
Joined: Aug 10 2006 - 3:28am
Last seen: 16 years 7 months ago

1 Answer:

Hi there,

I have set up a Database connection in iReport (via the Connections/Datasource section), and am calling a stored procedure within the report, but the connection doesn't seem to be closing. Is this because of the bug you mentioned, or is there a way to either force a connection to close or to pass the connection to the report so that i can close it.


hazman's picture
Joined: Mar 1 2007 - 1:25pm
Last seen: 16 years 3 weeks ago