| The jOOQ User Manual : SQL building : The DSLContext API : Custom Settings : Statement Type | previous : next |
Available in versions: Dev (3.17) | Latest (3.16) | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10 | 3.9 | 3.8 | 3.7
Statement Type
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
JDBC knows two types of statements:
- java.sql.PreparedStatement: This allows for sending bind variables to the server. jOOQ uses prepared statements by default.
- java.sql.Statement: Also "static statement". These do not support bind variables and may be useful for one-shot commands like DDL statements.
The statementType setting allows for overriding the default of using prepared statements internally. There are two possible options for this setting:
-
PREPARED_STATEMENT(the default): Use prepared statements. -
STATIC_STATEMENT: Use static statements. This enforces theparamType == INLINED. See parameter types
Example configuration
Settings settings = new Settings()
.withStatementType(StatementType.STATIC_STATEMENT); // Defaults to PREPARED_STATEMENT
Feedback
Do you have any feedback about this page? We'd love to hear it!