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.  inserting null in date field

    Posted Fri April 11, 2008 12:42 PM

    Hi

    when i tried to insert date with time stamp using batchInsert AS i found null at date field in database.The coulmn type is specified as DATE in db.

    But when i uesd insert service manually in custom AS date field is updating with time stamp.
    As per my flow i need to use only batchInsert AS

    The inputs for the BatchInsert AS
    input field type - java.util.Date

    The pipeline input for AS is of type java.util.Date(As we got this data by using the select query in the custom AS which has the inputs like
    JDBC FIELD TYPE as TIMESTAMP
    OUTPUT FIELD TYPE as java.util.Date)

    I have directly mapped the result of the select AS to batchInsert AS.
    Is there any conversions needed between these two AS.

    Can you please help me out

    Thnks&Regards
    soma


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


  • 2.  RE: inserting null in date field

    Posted Fri April 11, 2008 12:59 PM

    Hi
    the database we are using 10g
    webMethods 6.5
    jdbc thin driver
    ojdbc14.jar
    os IBM/AIX


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


Related Content