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

JDBC Adapter TIMESTAMP dataType Conversion

  • 1.  JDBC Adapter TIMESTAMP dataType Conversion

    Posted Fri July 22, 2016 12:18 PM

    Hi community,

    We are using wm9.7, JDBC Adapter 9.0 For JDBC Fix 8. Oracle DB we are using in 9i.
    i get only “07/05/2016” instead of “07/05/2016 XX:XX:XX” when I created a normal select adapter service, since there is no option of selecting JDBC datatype as “TIMESTAMP” i just have “DATE”.

    should we have to do some configuration changes or patches for wm9.7 to resolve this?

    Alternatively when i created a customSQL Adapter Service with the output field defined as TIMESTAMP, I was able to get the date and time stamp as desired.

    thanks for the help in advance.
    Regards,


    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: JDBC Adapter TIMESTAMP dataType Conversion

    Posted Fri July 22, 2016 07:09 PM

    select java.lang.string or setAsString instead of TimeStamp. Check if that works.


    #Integration-Server-and-ESB
    #webMethods


Related Content