When executing NXQL query:
While the statement is properly closed, the resultset is not closed on JDBCMapper.query.
According to the JDBC documentation everyting is ok
"A ResultSet object is automatically closed when the Statement object that generated it is closed"
But according to Oracle the only holdability supported by ResultSet is HOLD_CURSORS_OVER_COMMIT.
The last behavior may be responsible of " ORA-01000 maximum open cursors exceeded" errors.
Same problem on SQLDirectory.