Not closed SQL statements

[2002 JI Open Discussion]

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

[hazman]

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.

 

Thanks

 

Harry