For most of the stored procedures with a date argument, I am getting an error with the description:
"class java.lang.String cannot be cast to class java.sql.Date (java.lang.String is in module java.base of loader 'bootstrap'; java.sql.Date is in module java.sql of loader 'platform')"
errorType: MULE:UNKNOWN
Oddly enough, I have two stored procedures that are working as expected, but the other 15 throw this error. Any help is appreciated.
I tried a bunch of items for this:
- Forcing the DEPARTURE date to a java.sql.Date value when setting it, looks like the component still tries to do a string to date conversion
- Convert to HEX and use decode hex, still has string to date error
Ended up doing:
#["CALL GET_PAXMANIFEST_PASSENGER_SEATING(': ++ payload.DEPARTUREDATE ++ "', :FLIGHTNUMBER)
and testing the value early in to flow to make sure there aren't any SQL injection issues.
FYI: We are also using version 3.12.17 of the Snowflake JDBC driver. I know the latest is something in 3.13.* range, but that causes other issuse.
