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.  Date is reducing by 1 day

    Posted 04/06/09 11:28 AM

    Hi ,
    I am entering date using dateInput in my CAF protlet … updated to Oracle DB it is reduced by 1 day. Can u give me solution how to do that?

    Iam using ojdbc14.jar 10.2.0.1.0,
    The field datatype is DATE in Oracle and JDBC type in Adapter Service is DATE, mapped to Java.util.Date and working on that.

    Thanks,
    Rudrakanth.:confused:


    #BPM
    #webMethods-BPMS
    #webMethods


  • 2.  RE: Date is reducing by 1 day

    Posted 04/20/09 08:26 AM

    I once had exactly same issue.
    If you will note actually CAF will be sending the date reduced by 1 day. JDBC is doing what it is expected to do. Issue is on CAF side.
    I was able to resolve it by changing the type of field to Text Input and back to Date Input :smiley:


    #webMethods
    #BPM
    #webMethods-BPMS


  • 3.  RE: Date is reducing by 1 day

    Posted 03/06/11 01:55 PM

    I also met the issues , I have resolved and still use the date contorl
    We need to set the date of the timezone property of controls, The set value of Convert control is #{user.profile[“user.default.time_zone”]} when you display a datetime, The set value of date control is user when you input a datetime


    #BPM
    #webMethods-BPMS
    #webMethods