Hello, I am having trouble with writing to a db2 database table using the jdbc generic insert, or being more specific writing a timestamp format string to a timestamp column.
I have to read from a csv fle and insert the rows into a db2 database table
I can perfectly do so by skipping the timestamp column but that will cause the field in the table record to take the current timestamp value(which obviously is not the intended outcome)
when I try it with the date value i get the next error โBatch failure. The batch was submitted, but at least one exception occurred on an individual member of the batchโ, I only get this error when including the date in the mapper output to the jdbc insert.
the initial date&time string is in his format: โM/DD/YYYY HH.MMโ and I format it in two steps(mappers)
first: Date.parse($[โDate & Timeโ]).toLocaleDateTimeString() OUTPUT=>โ2018-08-21T16:48:00.000โ
second: ($DATE_PROCESSED.slice(0,10)+โ-โ+$DATE_PROCESSED.slice(11).replaceAll (โ:โ,โ.โ)+โ000โ).toString() OUTPUT=>โ2018-08-21-16.48.00.000000โ this is the format(TIMESTAMP) that is stored in the database but for some reason the insert still fails only when I include it in the mapper and I have tested the same string that the mapper gives me by inserting through query and it works fineโฆ I donโt know what could be messing in the middle that I am not seeingโฆ Iโd appreciate
any insights you can have on the way I am managing things.
THANK YOU.
