The jOOQ User Manual : SQL building : The DSLContext API : Custom Settings : Statement Type

previous : next

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 the paramType == 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>

The jOOQ User Manual : SQL building : The DSLContext API : Custom Settings : Statement Type

previous : next