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
Expand all | Collapse all

Adapter updating DataTypes

  • 1.  Adapter updating DataTypes

    Posted Wed June 28, 2006 10:52 AM

    Hi everybody,

    maybe this question has been asked before, but I could not find an answer to it.

    We’re running some JDBC-Adapter-Services (Select-Template) with about 200 columns. Some of the existing columns map from ColumnType “DATE” to JDBC-Type “TIMESTAMP” and to OutputFieldType “java.sql.Timestamp”.

    Now the database tables have been extended with some new columns. On pressing the “Insert Row”-Button at the SELECT-tab of the Adapter-Service
    ALL corresponding rows are updated to ColumnType “DATE” to JDBC-Type “Date” and to OutputFieldType “java.sql.Date”, what leeds to the often described problem of missing time information. OutputFieldType now can only be set to “java.sql.Date”, “java.util.Date” or “java.util.String”.

    How do I prevent JDBC-Adapter to update the DataTypes?

    Thanks in advance for any help…

    Kind regards,
    Max.

    Configuration:
    OS AIX 5.2
    webMethods 6.1
    writeTD(“rowdata-l”); WmJDBCAdapter Version 6.0.3.1
    JDBC-Driver: classes12.zip
    JVM: IBM 1.4.2.20 (SR3)
    Fixes: None

    or (with same effect)
    Windows XP Professional
    webMethods 6.1
    writeTD(“rowdata-l”); WmJDBCAdapter Version 6.0.3.1
    JDBC-Driver: ojdbc14.zip
    JVM: SUN 1.4.2 (48.0)
    Fixes: JDBC_6-0-3_FP1_Fix12


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 2.  RE: Adapter updating DataTypes

    Posted Thu June 29, 2006 04:41 AM

    Hi,
    For the columns you know that the DBColumnType “DATE” has the TimeStamp in it, manually change in your adapter service the JDBC-Type to “TIMESTAMP” and the OutputFieldType to “java.util.String”. You will get Timestamp from DB as string.

    HTH,
    Bhawesh.


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards