> Switch the auto-commit off. The driver has to close the result set when
> another statement (your subquery) is executed on the same connection -
> this is JDBC 3.0 requirement.

Thanks the helps. I think the auto-commit off my perfect way :)
I would like to test my subreports with iReport too.

Is it possible? Where can I set the auto-commit off mode in iReport?

Thx,
Csaba