create a web sevice in jdevelolper using the existing Java file

[tahir ahmed]

I am pl/sql developer and new to java, I want to create a web sevice in jdevelolper using the existing Java file eg.accessfile.java.
I like to how to open the existing .java in jdeveloper and using with this file I want to create the web sevice.
I already create the webservice using this tutorial in the below link but there they create Java class and then create web service. But I want to use the exisitng java file
http://www.baigzeeshan.com/2010/11/creating-webservice-from-java-class-in.html
Please help me where to start.

[Arun Kumar]

you could follow the same steps mentioned in the link/video (copy your java file content to the new file and create a web service out of it)

[tahir ahmed]

Thanks for the reply,
I can able to open and the exisitng Java and run succesfully. Again I stop when creating the web service in step 5 all the methods are disable and I can't proceed with out it it give me STATIC METHOD " method name" CANNOT BE PUBLISH IN WEB SERVICE if I remove the statiC in the java script then I can't able to compile and it's give me the error "Error(14,37): non-static method getPrintServices() cannot be referenced from a static context".
Please reply me how to solve this issue.

[Vijitha Kumara]

I haven't gone through the video you are following, but for the latter issue you are facing use an instance of the class and call the method "getPrintServices()" on that instance. Would that help here?

[tahir ahmed]

I was able to create the webservice and deployed into the webloigc server and successfully tested from the weblogic server. But when we call this webservice from the Oracle database using utl_http.
I am forwarding the WSDL file and the PL/SQL fucntion which calling the webservice in given below.
And how can I test this webservice from browser.
Please help me to resolve this.
Thanks in advance.

<?xml version="1.0" encoding="UTF-8" ?> 
- <!-- 
 Published by JAX-WS RI at http://jax-ws.dev.java.net. RI's version is Oracle JAX-WS 2.1.5. 
--> 
- <!-- 
 Generated by JAX-WS RI at http://jax-ws.dev.java.net. RI's version is Oracle JAX-WS 2.1.5. 
--> 
 <definitions xmlns:wssutil="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" xmlns:wsp="http://schemas.xmlsoap.org/ws/2004/09/policy" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:tns="http://Printfile/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.xmlsoap.org/wsdl/" targetNamespace="http://Printfile/" name="PrintService"> 
<wsp:UsingPolicy wssutil:Required="true" /> 
 <wsp:Policy wssutil:Id="Mtom.xml"> 
<ns1:OptimizedMimeSerialization xmlns:ns1="http://schemas.xmlsoap.org/ws/2004/09/policy/optimizedmimeserialization" /> 
</wsp:Policy> 
 <types> 
 <xsd:schema> 
<xsd:import namespace="http://Printfile/" schemaLocation="http://10.10.10.10:7001/Application10-Project1-context-root/PrintPort?xsd=1" /> 
</xsd:schema> 
</types> 
- <message name="printFile"> 
<part name="arg0" type="xsd:string" /> 
<part name="arg1" type="xsd:string" /> 
<part name="arg2" type="xsd:string" /> 
</message> 
<message name="printFileResponse" /> 
 <message name="Exception"> 
<part name="fault" element="tns:Exception" /> 
</message> 
 <portType name="Print"> 
 <operation name="printFile" parameterOrder="arg0 arg1 arg2"> 
<input message="tns:printFile" /> 
<output message="tns:printFileResponse" /> 
<fault message="tns:Exception" name="Exception" /> 
</operation> 
</portType> 
 <binding name="PrintPortBinding" type="tns:Print"> 
<wsp:PolicyReference URI="#Mtom.xml" /> 
<soap:binding transport="http://schemas.xmlsoap.org/soap/http" style="rpc" /> 
 <operation name="printFile"> 
<soap:operation soapAction="" /> 
 <input> 
<soap:body use="literal" namespace="http://Printfile/" /> 
</input> 
 <output> 
<soap:body use="literal" namespace="http://Printfile/" /> 
</output> 
 <fault name="Exception"> 
<soap:fault name="Exception" use="literal" /> 
</fault> 
</operation> 
</binding> 
 <service name="PrintService"> 
 <port name="PrintPort" binding="tns:PrintPortBinding"> 
<soap:address location="http://10.10.10.10:7001/Application10-Project1-context-root/PrintPort" /> 
</port> 
</service> 
</definitions>

create or replace FUNCTION webservice_print(
  p_printer in varchar2
  ,p_file in varchar2
  ,p_type in varchar2 default 'txt')
RETURN NUMBER IS
  v_debug_mode        BOOLEAN := FALSE;
  v_req               utl_http.req;
  v_resp              utl_http.resp;
  v_msg               VARCHAR2(80);
  v_entire_msg        VARCHAR2(32767) := NULL;
  v_conversion_factor NUMBER;
  v_url               VARCHAR2(256) :=
          'http://10.10.10.10:7001/'||
         'Application10-Project1-context-root/PrintPort?'||
          'arg0='||p_printer||
          'arg1='||p_file||
          'arg2='||p_type;
          --'&ToCurrency='||p_to_currency;
BEGIN
  v_req := utl_http.begin_request(url => v_url,method => 'GET');
  v_resp := utl_http.get_response(r => v_req);
  IF    v_debug_mode  THEN  
     dbms_output.put_line('HTTP Status Return code: '||v_resp.status_code);
  END IF;
  BEGIN
  LOOP
  utl_http.read_text(r => v_resp,data => v_msg);
         v_entire_msg := v_entire_msg||v_msg;
     END LOOP;
     EXCEPTION 
     WHEN  utl_http.end_of_body 
     THEN  --null;
     return (2);
  END;
--clean up the data received by the webservice
  v_entire_msg := REPLACE(v_entire_msg, chr(13));
  v_entire_msg := REPLACE(v_entire_msg, chr(10));
  v_entire_msg := REPLACE(v_entire_msg, 
     '<?xml version="1.0" encoding="UTF-8"?>');
  v_entire_msg := REPLACE(v_entire_msg, 
     '<double xmlns="http://10.10.10.10:7001/">');
  v_entire_msg := REPLACE(v_entire_msg, '</double>');
  IF    v_debug_mode
  THEN  dbms_output.put_line(v_entire_msg);
  END IF;
 BEGIN
     v_conversion_factor := to_number(v_entire_msg);
  EXCEPTION
     WHEN others 
     THEN v_conversion_factor :=3;
  END;
  utl_http.end_response(r => v_resp);
  RETURN v_conversion_factor;
EXCEPTION 
  WHEN  others 
  THEN  RETURN null;
END WEBSERVICE_PRINT;

[Vijitha Kumara]

And how can I test this webservice from browser.

You can write a servlet (and related other components needed) to be invoked as necessary, so that it talks to your DB function eventually. You can have the servlet then send the response to the browser...

[tahir ahmed]

Thanks for the reply. As I new to java & web services can please send me any sample for that which is related to my service as I have short time to complete this.
Thanks in advance.

[Vijitha Kumara]

Have a look at thid for a servlet example. And then you can call any other POJO bean method(s) form there which is responsible of handling procedure/function call to the DB. And then return any response as needed from the doGet() method itself.