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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only

  • 1.  Insertion of Float and Date

    Posted 03/09/05 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 03/09/05 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 03/10/05 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 03/10/05 05:06 AM

    Thanks for your Help RMG


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


Related Content