Available in versions: Dev (3.21) | Latest (3.20) | 3.19 | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11
OTHER (Object)
Supported by ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
The OTHER data type represents any unsupported data type, which jOOQ cannot represent and/or bind natively, or java.lang.Object in Java, or Types.OTHER in JDBC
While certain JDBC types can occasionally be passed through jOOQ transparently without jOOQ knowing about them (e.g. PostgreSQL's PGobject), it is never a good idea to rely on this implicit behaviour. It is always better to design a custom data type binding in order to make the binding and data type conversion explicit.
Unlike other data types, this type acts as a placeholder. It cannot be used in DDL statements or CAST expressions directly.
Feedback
Do you have any feedback about this page? We'd love to hear it!