Receiver JDBC Date format error.

[Former Member]

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_Nair · Accepted solution]

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)

[Former Member · Accepted solution]

Perfect Shabarish, after posting this I tried the string conactenate and was stuck with the quote problem. This blog was great help! and thanks a lot for sending the param for logs.

[Former Member]

It is common error while integrating XI and Oracle.

See this blog :

[ATE/TIME datatypes and Oracle Database|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/2002] [original link is broken] [original link is broken] [original link is broken];

Thanks

Farooq