I created a flow service that receives data from a SAP notification and this data must be inserted in an Oracle table.
This table contains a column that is using the DATE data type.
But, I didn’t figure out how can I insert the SAP date format ‘yyyy-mm-dd’ into this oracle table. It always gives me the following error:
Error: java.lang.ClassCastException: java.lang.String cannot be cast to java.util.Date
I tried the pub.date:dateTimeFormat to format the date as “dd/MMM/yy” but it gives me the same issue.
Please, what should I do to be able to insert the SAP Date format (yyyy-mm-dd as String) into an oracle table (as java.util.Date in my adapter service).