webMethods

webMethods

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
  • 1.  Changing JDBC Type in INSERT adapter

    Posted Mon February 06, 2012 01:51 PM

    Hi all,

    situation as follows.

    We have a date field in database and we want to insert dd.MM.yyyy hh:mm:ss.

    In adapter i see following:
    COLUMN - ‘name’
    Column Type - DATE
    JDBC Type - DATE
    Input Field - ‘name’
    Input Field Type - ‘java.util.Date’

    It is not working for us. But I have adapter that works fine. All same as above but.
    JDBC Type - TIMESTAMP
    Input Field Type - ‘java.sql.TimeStamp’

    Problem is that I cannot pick java.sql.TimeStamp from the list of Input Field Type and I cannot change JDBC Type to TIMESTAMP.

    Any thoughts how can i do one of these things?

    Thanks!


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


  • 2.  RE: Changing JDBC Type in INSERT adapter

    Posted Mon February 06, 2012 01:58 PM

    [ATTACH=CONFIG]832[/ATTACH]
    Upper one is the one I need,
    lower one is the one we have.

    How can i change JDBC type or how can I get java.sql.timestamp to Input Field Type list.
    want.png


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


  • 3.  RE: Changing JDBC Type in INSERT adapter

    Posted Tue February 07, 2012 10:30 AM

    I got it done with duplicating the first adapter. No other workaround found.


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


  • 4.  RE: Changing JDBC Type in INSERT adapter

    Posted Thu November 22, 2012 10:53 AM

    Hi,
    I am facing issue with insert adapter service.
    while listing all the columns in insert tab for one of the column I can not see the jdbc type and so while running this service that column is not comming for input. Oracle datatype for this column is sys.XMLType
    insertJDBCtype Error.jpg


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