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

String with a date say bDDMMMYYYYb to BrokerDate

  • 1.  String with a date say bDDMMMYYYYb to BrokerDate

    Posted Fri October 11, 2002 06:03 PM

    Hi!
    Using WM JDBC Adapter with Oracle thin driver connecting to a table X. Inserting column Y that is of type date. What is a good way to convert my string date before I map it to the Insert Operation field of Date (BrokerDate)? Just a beginner with JAVA. Thanks in advance


    #Integration-Server-and-ESB
    #broker
    #webMethods
    #Universal-Messaging-Broker


  • 2.  RE: String with a date say bDDMMMYYYYb to BrokerDate

    Posted Mon October 14, 2002 05:53 AM

    Hi all
    i am getting a BrokerDate object
    and then getting the string of that date
    and then getting the day,month and year
    by parsing the string
    then i am subracting the day by 1 and
    creating another BrokerObject and passing the original date
    and the date created by me to a operation step.
    The operation step return no error message and
    no values eventhough i have the records satisfying the condition !!!
    What may be the problem???
    it is urgent…!!!


    #Integration-Server-and-ESB
    #Universal-Messaging-Broker
    #webMethods
    #broker


  • 3.  RE: String with a date say bDDMMMYYYYb to BrokerDate

    Posted Mon October 14, 2002 08:23 PM

    Hi i’m not really sure about the broker date object but
    the format dd-MMM-yyyy is the correct one as far as java date object goes. I think it is still not doing anything because
    it doesn’t recognise the format.

    Hopefully this helps.


    #Integration-Server-and-ESB
    #Universal-Messaging-Broker
    #broker
    #webMethods


  • 4.  RE: String with a date say bDDMMMYYYYb to BrokerDate

    Posted Tue October 15, 2002 05:34 PM

    Dave, check out my reply to your query on the Advantage website!!!


    #broker
    #Integration-Server-and-ESB
    #Universal-Messaging-Broker
    #webMethods