IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

Timestamp is not reflecting during Insert into Oracle DB

  • 1.  Timestamp is not reflecting during Insert into Oracle DB

    Posted Mon August 14, 2006 03:24 PM

    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


    #webMethods-General
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: Timestamp is not reflecting during Insert into Oracle DB

    Posted Tue August 15, 2006 12:19 AM

    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.


    #webMethods
    #webMethods-General
    #Integration-Server-and-ESB


  • 3.  RE: Timestamp is not reflecting during Insert into Oracle DB

    Posted Tue August 15, 2006 02:02 AM

    You could try:

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


    #webMethods
    #Integration-Server-and-ESB
    #webMethods-General


Related Content