Update Oracle with timestamp

[Former Member]

How do I go about updating oracle DB table with timestamp from XI using JDBC receiver?

[Former Member]

Hi,

write a Simple User Defined Function using Java (simpledatefomat)and insert the same into JDBC table

Regards,

Suresh

[Former Member]

Hi SSG,

1) Generate a string in message mapping for the datetimestamp. You could also do this in the SQL statement by using the oracle SYSDATE function.

2) In the JDBC receiver channel SQL statement you have 2 choices:

- If the string is in the default datetimestamp format for your oracle DB, then you can insert it directly.

- Use the to_date function to convert the string to an Oracle date. I'd recommend this approach. Here's some documentation for this function:

http://www.techonthenet.com/oracle/functions/to_date.php

Thanks,

Jesse

[Former Member]

Hi Wolff,

I defined my output type of 'XSTRING' type and then moved the constant 'SYSTIMESTAMP' to it. And this worked.

[Former Member]

I am not sure whether you have any function available in JDBC adapter to place the Time stamp.

But if you have the field "TimeStamp" in your DB table, then use the CurrentDate function in the message mapping, change the properties for this function as per your requiremet.