Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10
JDBC Flags
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
JDBC statements feature a couple of flags that influence the execution of such a statement. Each of these flags can be configured through jOOQ's org.jooq.Query and org.jooq.ResultQuery on a statement-per-statement basis, but there's also the possibility to centrally specify a value for these flags. These are the three flags:
-
queryTimeout: The JDBC statement timeout in seconds. Corresponds toQuery.queryTimeout()orStatement.setQueryTimeout() -
maxRows: The maximum number of rows returned by the JDBC statement. Corresponds toResultQuery.maxRows()orStatement.setMaxRows() -
fetchSize: The number of rows to be buffered by the JDBC ResultSet. Corresponds toResultQuery.fetchSize()orStatement.setFetchSize()
All of these flags are JDBC-only features with no direct effect on jOOQ. jOOQ only passes them through to the underlying statement.
Example configuration
Settings settings = new Settings()
.withQueryTimeout(5)
.withQueryPoolable(DEFAULT)
.withMaxRows(1000)
.withFetchSize(20);
Feedback
Do you have any feedback about this page? We'd love to hear it!