Best guess here is that the query execution without the ORDER BY or LIMIT clauses takes too long, and exceeds a timeout (like socketTimeout, or in a router), causing the network connection to be closed. Maybe the full stack trace and the driver configuration options would provide more clues?
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.