The jOOQ User Manual SQL building The DSLContext API Custom Settings JSR 310 type binding

previous : next

JSR 310 type binding

Supported by ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

Historically, JDBC drivers had poor support for the java.time (JSR 310) types, which is why jOOQ encodes some of them in a more compatible way when binding them to JDBC statements. Most modern drivers support these types natively, and binding them natively may perform better both on the client and on the server. The following settings govern this behaviour:

• bindOffsetDateTimeType: Whether java.time.OffsetDateTime values are bound natively using PreparedStatement.setObject(). The default is false, in case of which jOOQ binds them as formatted strings in many dialects.
• bindOffsetTimeType: Whether java.time.OffsetTime values are bound natively using PreparedStatement.setObject(). The default is false, in case of which jOOQ binds them as formatted strings in many dialects.

See also the manual's sections about the OffsetDateTime and OffsetTime data types.

Example configuration

Settings settings = new Settings()
    .withBindOffsetDateTimeType(true) // Defaults to false
    .withBindOffsetTimeType(true);    // Defaults to false

The jOOQ User Manual SQL building The DSLContext API Custom Settings JSR 310 type binding

previous : next