Hi Sevket, Regarding the CSV serialisation, there's a feature request for adding formatters: https://github.com/jOOQ/jOOQ/issues/5673
This should address both issues that you're mentioning. You can obviously achieve the same thing already today by attaching a Converter to your DateTime field that converts the temporal value to a String format of your liking, directly in the query. When importing, the listener API can probably help? https://www.jooq.org/doc/latest/manual/sql-execution/importing/importing-listeners/ Best Regards, Lukas On Thu, Nov 27, 2025 at 6:17 PM Şevket Gökay <[email protected]> wrote: > Hello everyone, > > a very happy user of Jooq for more than 10 years here in my project: > https://github.com/steve-community/steve > > Recently, I wanted to introduce a feature to export and import all data as > CSV files in one ZIP file: > https://github.com/steve-community/steve/pull/1874 > > Since the data can be big, exports are happening in batches with a Cursor > in a streaming mode. Imports are using Loader API. > > Now, this project is still using joda DateTime, so I have the necessary > converter ( > https://github.com/steve-community/steve/blob/master/src/main/java/de/rwth/idsg/steve/utils/DateTimeConverter.java) > and it is attached with maven plugin during codegen to each field. > > The problem I face is the following: Database timestamps are mapped to > org.joda.time.DateTime and DateTime.toString() method is used during CSV > serialization. I cannot modify this behavior (right?). Therefore, I have > values such as "2025-11-20T17:13:20.389Z" in CSV. During the importing from > CSV, the Loader API is trying to convert this directly to Timestamp, which > fails and because of which I have null values in my tables. > > How can I elegantly influence the CSV reading and writing with regards to > the timestamp format? I saw the existence of org.jooq.ConverterProvider and > have set it globally in my Jooq Config instance, but I saw that it was not > used during imports. Do you have any tips? Am I missing something? > > Kind regards, > Sevket > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion visit > https://groups.google.com/d/msgid/jooq-user/c0b31fdd-fa3f-42cf-8d5f-8762c6aea416n%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/c0b31fdd-fa3f-42cf-8d5f-8762c6aea416n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO56eS%2BTqcaP37uMgbYjNd3kp6gg8h%2BK_%3DbJv01UDennGQ%40mail.gmail.com.
