> Have You got any information how can I solve this error?

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.

Roman