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

How to insert Decimal and Bigdecimal in JDBC Adpter Service

  • 1.  How to insert Decimal and Bigdecimal in JDBC Adpter Service

    Posted Tue September 27, 2005 10:38 AM

    I am getting two fields as Double and Integer in my cannonical document which i have to insert in Table using JDBCAdapter Servcies.
    But when i am making input as BigDecimal in my service it showing me as an object in my input parameters which i am not able to map with Double or integer.
    Please guide me how to insert these values ???


    #Flow-and-Java-services
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: How to insert Decimal and Bigdecimal in JDBC Adpter Service

    Posted Tue September 27, 2005 09:35 PM

    Hello,
    You should make a simple convert java service that takes in your Integer or Double and converts it to a java.math.BigDecimal. You output should look like an unknown Object, and that can be mapped to your adapter service. Good day.

    Yemi Bedu


    #Integration-Server-and-ESB
    #Flow-and-Java-services
    #webMethods


  • 3.  RE: How to insert Decimal and Bigdecimal in JDBC Adpter Service

    Posted Tue September 27, 2005 11:06 PM

    Pankaj,

    In the JDBCAdapter insert template service select the JDBCField type to java.lang.string this will show as string in the service outpt.So you can map the canonical bigDecimal to adapter service input directly.

    I am sure this will work and inserts to DB.

    HTH,
    RMG


    #Integration-Server-and-ESB
    #Flow-and-Java-services
    #webMethods