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 Type DATE instead of TIMESTAMP

  • 1.  JDBC Type DATE instead of TIMESTAMP

    Posted Tue June 20, 2017 08:30 AM

    Hi there,

    We are encountering a very strange issue after installing the latest fixes on our server. When using an adapter service of type SELECT the fields of type DATE in our database are returned without the time (just the date is retrieved). In the JDBCType field we have DATE instead of TIMESTAMP. Do you have any idea how can we manage to get the full date in the adapter service?

    Our settings:

    WmJDBCAdapter version → 6.5, fix 55 (JDBC_6.5_Fix55)
    IS Version: 8.2.2.0
    Fix level: IS_8.2_SP2_Core_Fix14

    Thank you in advance!


    #Integration-Server-and-ESB
    #B2B-Integration
    #webMethods


  • 2.  RE: JDBC Type DATE instead of TIMESTAMP

    Posted Tue June 20, 2017 02:49 PM

    what’s the reason you don’t use TIMESTAMP type for JDBC type?
    the driver may trim off the time fields if the you use DATE as JDBC type


    #webMethods
    #B2B-Integration
    #Integration-Server-and-ESB


Related Content