3.13. Setting Partial Results Mode

Partial results mode is off by default but you can turn it on for all queries in a connection by using either setPartialResultsMode(true) on a DataSource or partialResultsMode=true on a JDBC URL. In either case, you can toggle partial results mode on or off later with a SET statement.

This is how you configure the partial results mode using the SET statement:

Statement statement = ...obtain statement from Connection...
statement.execute("set partialResultsMode true");