| The jOOQ User Manual : SQL building : The DSLContext API : Custom Settings : Statement Type | previous : next |
Available in versions: Dev (3.18) | Latest (3.17) | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10 | 3.9 | 3.8
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!