Hello Jon > What I'm confused on is how JOOQ handles writing to vendor specific data > types like oracle's TIMESTAMPTZ.
jOOQ generally uses those data types that are available through JDBC. In this case, the best matching data type is probably java.sql.Timestamp. > Also, if JOOQ does not handle a case where a column is a custom data type > like oracle's TIMESTAMPTZ, how do I use JOOQ to query and oracle table to > pull back the table's schema/metadata. The general approach would be to use jOOQ's code generator as described in the tutorial: http://www.jooq.org/doc/2.6/manual/getting-started/tutorials/jooq-in-7-steps/ It will then generate the necessary meta data for type-safe data type handling. Since you ultimately want to convert from / to jodatime DateTime objects, you may want to consider the manual's sections about custom data type conversion. This section explains what a converter is: http://www.jooq.org/doc/2.6/manual/sql-execution/fetching/data-type-conversion/ And this section explains how to let jOOQ's code generator apply converters to generated meta data: http://www.jooq.org/doc/2.6/manual/code-generation/custom-data-types/ Hope this helps, Lukas
