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.  How to insert data from JSP to Oracle

    Posted 10/24/05 03:11 PM

    Hi,

    I want to insert ‘ename’ and ‘empid’ from jsp to oracle d/b by insert adapter service.
    how can i do this in webMethods?
    Can anyone help me out.
    i’m calling dsp from jsp where dsp is invoking a particular adapter service.

    JSP:

    <form>
    Enter Employee Name : input type=“text” name=“ENAME”
    Enter Employee ID : input type=“text” name=“EMPID”
    input type=“submit” name=“submit” value=“submit”

    DSP:

    %invoke POC:UseCases.Scenario_1:insertService%
    %rename ENAME ENAME -copy%
    %rename EMPID EMPID -copy%
    %endinvoke%

    It’s not working.Please correct it and let me know.

    Thanks in advance,
    Ganesh


    #webMethods
    #Integration-Server-and-ESB
    #Flow-and-Java-services


  • 2.  RE: How to insert data from JSP to Oracle

    Posted 10/24/05 08:50 PM

    Hi,

    Can we know what error you are getting. Please provide the details

    Thanks,


    #Integration-Server-and-ESB
    #webMethods
    #Flow-and-Java-services


  • 3.  RE: How to insert data from JSP to Oracle

    Posted 10/25/05 05:30 AM

    Thanks Muneer,
    i’m not getting any error.
    DSP page is invoking the service but the wm service is not getting values from dsp page.So in d/b null values are getting inserted.

    DSP:

    %invoke UseCases.Scenario_1:insertByDspService%
    %rename ENAME ENAME -copy%
    %rename EMPID EMPID -copy%
    %endinvoke%

    How can i achieve this problem?

    Thanks,
    Ganesh


    #Integration-Server-and-ESB
    #Flow-and-Java-services
    #webMethods


  • 4.  RE: How to insert data from JSP to Oracle

    Posted 10/26/05 01:36 PM

    Hi Ganesh,

         Try resetting the Caches in the Property panel. Hope this will solve your problem otherwise keep posting. And please use the savePipelinetoFile and restorePiplinefromFile service in your DSP service so it’s easy to know what data is coming from the DSP page to service. 
    

    Thanks,


    #webMethods
    #Flow-and-Java-services
    #Integration-Server-and-ESB


  • 5.  RE: How to insert data from JSP to Oracle

    Posted 10/26/05 03:22 PM

    Hi Ganesh,

         One more thing the variable names in the DSP should be matched with the service input and out variables. 
    

    Thanks


    #Flow-and-Java-services
    #webMethods
    #Integration-Server-and-ESB


  • 6.  RE: How to insert data from JSP to Oracle

    Posted 10/26/05 03:41 PM

    Oh! thanks to all.
    It’s working now.
    Problem is i gave improper service name.

    Thanks,
    Ganesh


    #Integration-Server-and-ESB
    #Flow-and-Java-services
    #webMethods