Timestamp is not reflecting during Insert into Oracle DB

, ,
1

Hi,

While Inserting the fields into the Oracle DB the timestamp is not reflecting.

I have selected java.util.date as the Input Field Type.

I have applied the backword compatibility for oracle database.

Kindly sujest me what else can i try to reflect the Timestamp in the database.
Its very Urgent.

Thanks and Regards,
Ankit

2

Ankit,

There is alot around this issue with Oracle and the way DATE and TIMESTAMP fields are handled which has to do with Oracle’s JDBC driver and how the column is specified.

Have a look at http://advantage.webmethods.com/article/?id=SR-1-49407975

  • or search the Advantage site for “Oracle Date compatibility”

  • or search the net “Oracle Date Timestamp compatibility” to find possible work-arounds.

3

You could try:

to_timestamp(?,‘YYYY-MM-DD HH24:MI:SS.FF3’) with string as input in a custom sql…