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.
