Receiver JDBC Date format error.
We have scenario with JDBC receiver channel. The date format which is being passed is DD/MM/YYYY HH:MM:SS. It throws the exception ORA-01843: not a valid month on receiver end. On receiver end the insert command works with to_date conversion function.
Is there any way to use the to_date function in XI or else how do we resolve this.
Is it possible to see the sql string (after converion from XML) which is being issued to target ( JDBC) end.
Any pointer will be great help
Shabarish Vijayakumar replied
For seeing the SQL query,
JDBC Receiver Adapter Parameters - Additional Parameter
Parameter name: "logSQLStatement"
Parameter type: boolean
Parameter value: true for any string value, false only for empty string
Parameter value default: false (empty String)