Tipps & Tricks
- Oracle (TM) drivers do not explicitly close cursors that they
have opened when answering a request for primary key references, index
information of a table or the like. This is an error because the JDBC
api doesn't give a chance to close the cursor from outside the method.
- Workaround: As this is the case with index tables which cannot
be automatically detected you should skip those tables in search
operations (not enclose them in the selected scope). Otherwise all
searches over that kind of tables lead to an exception and leave a
cursor open, which will quickly let the connection run out of available
cursors.