Wednesday, April 17, 2013

[android help] SOAP response not in XML format


I am developing an application which consume SOAP web service.


When i am getting the response in text view or in log-cat it is in following format as :



anyType{Results=anyType{Row=anyType{NAME=Demo; EMAIL=m.m@gmail.com; PHONENO=98607xxxxx; }; }; }


But on browser the response is like :



xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:ns0="http://testing.oi.com/">





Demo
m.m@gmail.com
98607xxxxx








My code of calling SOAP web service is as follows :



String NAMESPACE = "http://testing.oi.com/";
String URL = "http://192.168.1.xxx:8888/Testing-DemoTest-context-root/TestDemoSoapHttpPort";
String SOAP_ACTION = "http://testing.xx.com/getDetails";
String METHOD_NAME = "getDetails";

//Initialize soap request + add parameters
SoapObject request = new SoapObject(NAMESPACE, METHOD_NAME);

//Declare the version of the SOAP request
SoapSerializationEnvelope envelope = new SoapSerializationEnvelope(SoapEnvelope.VER11);
envelope.dotNet = true;
envelope.setOutputSoapObject(request);
envelope.implicitTypes = false;

HttpTransportSE androidHttpTransport = new HttpTransportSE(URL);

try {
androidHttpTransport.debug = true;
//this is the actual part that will call the
androidHttpTransport.call(SOAP_ACTION, envelope);
// Get the SoapResult from the envelope body.
SoapObject result = (SoapObject)envelope.bodyIn;
//Xml.parse(result.toString(), dataHandler);
hotelDetails = result.getProperty(0).toString();
Log.d("Rsp",Details);
} catch (Exception e) {
e.printStackTrace();
}

tv.setText(hotelDetails);


My Java web service code is as follows :



public class Test {
public Test() {
}
// Global Variable
Connection con;
CallableStatement cst;
String response;
ResultSet rs;
Statement stmt;

//DataBase Connection
public static Connection getConnection(){
Connection con;
con = null;

try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
System.out.println("Server Connection Failed");
}

String url="jdbc:oracle:thin:@abc.def.com:PortNo:SID";
try {
con=DriverManager.getConnection(url,"UserName","Password");
if(con!=null){
System.out.println("Connection Success"+"\n");
}
} catch (SQLException e) {

System.out.println("Connection Failed");
}
return(con);
}

//XML Document Creation.
public static Document createXMLDocument(ResultSet resultset, Document doc){
ResultSetMetaData rsmd;
DocumentBuilderFactory factory;
DocumentBuilder builder;
doc = null;
Element results;
int colCount;
Connection con = getConnection();

try{
factory = DocumentBuilderFactory.newInstance();
builder= factory.newDocumentBuilder();
doc= builder.newDocument();
results = doc.createElement("Results");
doc.appendChild(results);
rsmd = resultset.getMetaData();
colCount = rsmd.getColumnCount();

while (resultset.next()){
Element row = doc.createElement("Row");
results.appendChild(row);

for (int i = 1; i <= colCount; i++){
String columnName = rsmd.getColumnName(i);
Object value = resultset.getObject(i);
if(value==null){
value=" ";
}

Element node = doc.createElement(columnName);
if(columnName.equalsIgnoreCase("BEGIN_DATE")){
String date= resultset.getString(i);
node.appendChild(doc.createTextNode(date));
row.appendChild(node);
}else{
node.appendChild(doc.createTextNode(value.toString()));
row.appendChild(node);
}
}
}
}catch (Exception e) {
e.printStackTrace();
}
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
return(doc);
}

// Call Details
@WebMethod
public Document getDetails(){
Document doc;
doc = null;
con=getConnection();
try {
cst= con.prepareCall("{call callDetails (?)}");
cst.registerOutParameter(1,OracleTypes.CURSOR);
cst.execute();
rs = (ResultSet)cst.getObject(1);
doc = createXMLDocument(rs,doc);
}catch (SQLException e) {
System.out.println("No Such Record");
}

try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
return(doc);
}


I want the response as like it is on browser in string so that i can use sax parsing and parse data. I am not getting what is the issue that why i am getting such response.


Please guide me in this issue or suggest me what should i do now. I am in the middle of app and can not able to move farther.



.

stackoverflow.comm

No comments:

Post a Comment

Google Voice on T-Mobile? [General]

Google Voice on T-Mobile? So I recently switched from a GNex on Verizon to a Moto X DE on T-Mobile. I had always used Google Voice for my v...