Available in versions: Dev (3.19) | Latest (3.18) | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10 | 3.9
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
Programmatic configuration
Settings settings = new Settings()
.withStatementType(StatementType.STATIC_STATEMENT); // Defaults to PREPARED_STATEMENT
XML configuration
<settings xmlns="http://www.jooq.org/xsd/jooq-runtime-3.9.0.xsd"> <statementType>STATIC_STATEMENT</statementType> </settings>
Feedback
Do you have any feedback about this page? We'd love to hear it!