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,
Peter





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

Hi,

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,
Teodor