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

  • 1.  Insertion of Float and Date

    Posted Wed March 09, 2005 12:23 PM

    hi,
    I have created an Oracle table using JDBC adapter CustomSQL service
    in WM Developer6.1
    create table emp(eno Number(3),
    ename varchar2(10),
    doj Date,
    salary number(7,2))
    when i tried to insert values it provides null values for the fields except for the column ename.
    what i have to do for inserting date and number values.
    i have just started wm so please help me…


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


  • 2.  RE: Insertion of Float and Date

    Posted Wed March 09, 2005 03:03 PM

    Parani,

    If you are sure emp table is created successfully,then you can use InsertSQL template and using this for Number,date etc… choose the JDBC FieldType as java.lang.string.

    HTH,
    RMG>


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


  • 3.  RE: Insertion of Float and Date

    Posted Thu March 10, 2005 05:06 AM

    Thanks for your Help RMG


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


  • 4.  RE: Insertion of Float and Date

    Posted Thu March 10, 2005 05:06 AM

    Thanks for your Help RMG


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


Related Content