How to insert data from JSP to Oracle

, ,
1

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

2

Hi,

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

Thanks,

3

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

4

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,

5

Hi Ganesh,

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

Thanks

6

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

Thanks,
Ganesh