Wap Rau

Ivan Krizsan wrote:Hi!
You should really try to avoid that kind of multidimensional arrays. It makes your code much more difficult to understand and maintain.
Instead, implement a Java-bean class that represents one row of data from, in this case, the database.
Then, for each row in the database query result, create an instance and populate its data.
Finally, insert each instance of the Java-bean in an array and return that array.
Best wishes!

Thanks Ivan Krizsan, It worked.

Arun Kumar wrote:Try this in your code
@SOAPBinding
(
style = SOAPBinding.Style.DOCUMENT,
use = SOAPBinding.Use.LITERAL,
parameterStyle = SOAPBinding.ParameterStyle.WRAPPED
)

Thanks Arun Kumar for your reply. I will try your solution. Thanks again for responding.

Ivan Krizsan wrote:Hi!
I think that the reason for the element in question being named <item> may be related to the fact that you use RPC binding.
Have you tried using DOCUMENT style binding?
Best wishes!

Thanks Ivan Krizsan, for your reply. I am very new to Web Services. Could you provide me with links to the resources for such DOCUMENT style binding?

Thanks again,

Wap Rau

Ivan Krizsan wrote:Hi!
You should really try to avoid that kind of multidimensional arrays. It makes your code much more difficult to understand and maintain.
Instead, implement a Java-bean class that represents one row of data from, in this case, the database.
Then, for each row in the database query result, create an instance and populate its data.
Finally, insert each instance of the Java-bean in an array and return that array.
Best wishes!

Thanks Ivan Krizsan, for your reply. I will try your solution.

I am very new to Web Services. I am creating Apache CXF (apache-cxf-2.5.0) SOAP based Web Services. It creates WSDL from Java class (Java first approach).

When Web Service is called I am returning 2D array as a response. This is my Java class:

package com.abcd.shoppingcart; import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement; import javax.jws.WebService; import org.jboss.wsf.spi.annotation.WebContext; import com.abcd.db.DBConnection; @WebService(endpointInterface = "com.abcd.shoppingcart.GetMerchantsCardsListInterface", serviceName = "GetMerchantsCardsList6") @WebContext(contextRoot = "/", urlPattern = "/SrvGetmerchantsCardsList.jsp") public class GetMerchantsCardsList6 implements GetMerchantsCardsListInterface { public String[][] returnMerchantsCardsList(int pageNumber, int recordsPerPage) { DBConnection dbConnection; Connection con = null; Statement stmt = null; ResultSet rset = null; String sqlSelect = null; String[][] cardData = null; int columnNo = 1, rowNo = 1, totalRows = 0, totalColumns = 7; int totalPageCount = 0, totalNumberOfCards = 0; int startingRecordNumber = 0; int breakRecordsPerPage = 0; dbConnection = new DBConnection(); try { con = dbConnection.getConnection(); stmt = con.createStatement(); sqlSelect = "SELECT " + " DISTINCT GT.MerchantId, G.MerchantName, GT.GiftCardId, GT.CardNumber, GT.CardValue, " + " CONCAT('imageurl/', GT.ImageName), " + "\"" + totalPageCount + "\"" + " FROM giftcardtransactions GT, giftcard G " + " WHERE GT.MerchantId " + " IN " + " ( " + " SELECT DISTINCT GT.MerchantId " + " FROM giftcard G ,giftcardtransactions GT " + " WHERE G.ID>0 " + " AND G.ID = GT.GiftCardId AND (GT.CrQnty-GT.DrQnty)>0 " + " ) " + " AND (GT.CrQnty-GT.DrQnty)>0 " + " AND GT.MerchantId = G.MerchantId " + " GROUP BY GT.MerchantId " + " ORDER BY GT.CardValue DESC "; rset = stmt.executeQuery(sqlSelect); rset.last(); totalRows = rset.getRow(); totalNumberOfCards = totalRows; totalPageCount = totalNumberOfCards / recordsPerPage; sqlSelect = "SELECT " + " DISTINCT GT.MerchantId, G.MerchantName, GT.GiftCardId, GT.CardNumber, GT.CardValue, " + " CONCAT('/abcd/giftcards/', GT.ImageName), " + "\"" + totalPageCount + "\"" + " FROM giftcardtransactions GT, giftcard G " + " WHERE GT.MerchantId " + " IN " + " ( " + " SELECT DISTINCT GT.MerchantId " + " FROM giftcard G ,giftcardtransactions GT " + " WHERE G.ID>0 " + " AND G.ID = GT.GiftCardId AND (GT.CrQnty-GT.DrQnty)>0 " + " ) " + " AND (GT.CrQnty-GT.DrQnty)>0 " + " AND GT.MerchantId = G.MerchantId " + " GROUP BY GT.MerchantId " + " ORDER BY GT.CardValue DESC "; rset = stmt.executeQuery(sqlSelect); totalRows++; rset.beforeFirst(); startingRecordNumber = ((pageNumber - 1) * recordsPerPage) + 1; breakRecordsPerPage = startingRecordNumber + recordsPerPage - 1; cardData = new String[recordsPerPage][totalColumns]; int rowCardData = 0, columnCardData = 0; while (rset.next()) { if (rowNo > breakRecordsPerPage) break; columnNo = 1;columnCardData=0; if (rowNo >= startingRecordNumber) { while (columnNo <= totalColumns) { //System.out.print("cardData[" + rowCardData +"][" + columnCardData + "]:"); cardData[rowCardData][columnCardData] = rset.getString(columnNo); //System.out.print(cardData[rowCardData][columnCardData] + " "); columnNo++;columnCardData++; } rowCardData++; } rowNo++; //System.out.println(); } rset.close(); stmt.close(); con.close(); } catch (Exception e) { System.out.println(e.getMessage()); } finally { //System.out.println("In finally"); } return cardData; } }
This is the response to the request I get when Web Service is called:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <ns2:returnMerchantsCardsListResponse xmlns:ns2="http://shoppingcart.abcd.com/"> <return> <item>17</item> <item>Disney</item> <item>222</item> <item>gjkjffkgjkfg</item> <item>50.00</item> <item>/abcd/giftcards/dis_mall.jpg</item> <item>4</item> </return> <return> <item>20</item> <item>Banana republic</item> <item>38</item> <item>gjkjffkgjkfg</item> <item>25.00</item> <item>/abcd/giftcards/gapoldnavy_mall.jpg</item> <item>4</item> </return> <return> <item>14</item> <item>JCPenny</item> <item>219</item> <item>gjkjffkgjkfg</item> <item>25.00</item> <item>/abcd/giftcards/jcp_mall.jpg</item> <item>4</item> </return> <return> <item>6</item> <item>Fandango</item> <item>211</item> <item>gjkjffkgjkfg</item> <item>25.00</item> <item>/abcd/giftcards/fan_mall.jpg</item> <item>4</item> </return> <return> <item>16</item> <item>Toys R Us</item> <item>221</item> <item>gjkjffkgjkfg</item> <item>25.00</item> <item>/abcd/giftcards/toy_mall.jpg</item> <item>4</item> </return> </ns2:returnMerchantsCardsListResponse> </soap:Body> </soap:Envelope>
The Response that I get from the webservice has a tag <item> under <return> tag. However, I want <parameter-name> instead of <item> like this:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <ns2:returnMerchantsCardsListResponse xmlns:ns2="http://shoppingcart.abcd.com/"> <return> <merchantId>17</merchantId> <merchantName>Disney</merchantName> <giftCardId>222</giftCardId> <giftCardNumber>gjkjffkgjkfg</giftCardNumber> <cardValue>50.00</cardValue> <giftCardImageURL>/abcd/giftcards/dis_mall.jpg</giftCardImageURL> <totalPageCount>4</totalPageCount> </return> <return> <merchantId>20</merchantId> <merchantName>Banana republic</merchantName> <giftCardId>38</giftCardId> <giftCardNumber>gjkjffkgjkfg</giftCardNumber> <cardValue>25.00</cardValue> <giftCardImageURL>/abcd/giftcards/gapoldnavy_mall.jpg</giftCardImageURL> <totalPageCount>4</totalPageCount> </return> <return> <merchantId>14</merchantId> <merchantName>JCPenny</merchantName> <giftCardId>219</giftCardId> <giftCardNumber>gjkjffkgjkfg</giftCardNumber> <cardValue>25.00</cardValue> <giftCardImageURL>/abcd/giftcards/jcp_mall.jpg</giftCardImageURL> <totalPageCount>4</totalPageCount> </return> <return> <merchantId>6</merchantId> <merchantName>Fandango</merchantName> <giftCardId>211</giftCardId> <giftCardNumber>gjkjffkgjkfg</giftCardNumber> <cardValue>25.00</cardValue> <giftCardImageURL>/abcd/giftcards/fan_mall.jpg</giftCardImageURL> <totalPageCount>4</itotalPageCount> </return> <return> <merchantId>16</merchantId> <merchantName>Toys R Us</merchantName> <giftCardId>221</giftCardId> <giftCardNumber>gjkjffkgjkfg</giftCardNumber> <cardValue>25.00</cardValue> <giftCardImageURL>/abcd/giftcards/toy_mall.jpg</giftCardImageURL> <totalPageCount>4</totalPageCount> </return> </ns2:returnMerchantsCardsListResponse> </soap:Body> </soap:Envelope>
How to do it? Thanks.

Hello Nitin Bhardwaj,

Have you ever been able to get <item> named as <company>? If yes, how?

Thanks.

Wap Rau

My problem is more or less solved. The problem was with my Java class in which I was having class level variables. I changed it and made it method level variables and now I am getting result as expected.

Thank you.

I am very new to Web Services. I am creating Apache CXF (apache-cxf-2.5.0) SOAP based Web Services. It creates WSDL from Java class (Java first approach).

Following is my Java class:


package com.abcd.shoppingcart; import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement; import javax.jws.WebService; import org.jboss.wsf.spi.annotation.WebContext; import com.abcd.db.DBConnection; @WebService(endpointInterface = "com.abcd.shoppingcart.GetMerchantsCardsListInterface", serviceName = "GetMerchantsCardsList4") @WebContext( contextRoot = "/" , urlPattern="/SrvGetmerchantsCardsList.jsp" ) public class GetMerchantsCardsList4 implements GetMerchantsCardsListInterface { private DBConnection dbConnection; private Connection con = null; private Statement stmt = null; private ResultSet rset = null; private String sqlSelect = null; String[][] cardData = null; int columnNo = 1, rowNo = 1, totalRows = 0, totalColumns = 6; public String[][] returnMerchantsCardsList(int pageNumber, int recordsPerPage) { dbConnection = new DBConnection(); sqlSelect = "SELECT " + " giftcard.MerchantId, giftcard.MerchantName, giftcard.ID AS GiftCardId, giftcardtransactions.CardNumber AS GiftCardNumber, " + " giftcardtransactions.CardValue, giftcardtransactions.ImageName " + " FROM merchant " + " INNER JOIN giftcard ON giftcard.MerchantId = merchant.ID " + " INNER JOIN giftcardtransactions ON giftcardtransactions.id = merchant.ID " + " WHERE merchant.isActive = '1' " + " GROUP BY giftcard.MerchantId"; try { con = dbConnection.getConnection(); stmt = con.createStatement(); rset = stmt.executeQuery(sqlSelect); rset.last(); totalRows = rset.getRow(); totalRows++; totalColumns++; cardData = new String[totalRows][totalColumns]; rset.beforeFirst(); while (rset.next()) { columnNo = 1; while (columnNo < totalColumns) { cardData[rowNo][columnNo] = rset.getString(columnNo); //System.out.print(cardData[rowNo][columnNo] + "\t\t"); columnNo++; } rowNo++; System.out.println(); } rset.close(); stmt.close(); con.close(); } catch (Exception e) { System.out.println(e.getMessage()); } finally { } return cardData; } }
This is WSDL created at the specified URL:

<wsdl:definitions xmlns:ns1="http://schemas.xmlsoap.org/soap/http" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:tns="http://shoppingcart.abcd.com/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="GetMerchantsCardsList4" targetNamespace="http://shoppingcart.abcd.com/"> <wsdl:types> <xs:schema xmlns:ns1="http://jaxb.dev.java.net/array" xmlns:tns="http://shoppingcart.abcd.com/" xmlns:xs="http://www.w3.org/2001/XMLSchema" attributeFormDefault="unqualified" elementFormDefault="unqualified" targetNamespace="http://shoppingcart.abcd.com/"> <xs:import namespace="http://jaxb.dev.java.net/array"/> <xs:element name="returnMerchantsCardsList" type="tns:returnMerchantsCardsList"/> <xs:element name="returnMerchantsCardsListResponse" type="tns:returnMerchantsCardsListResponse"/> <xs:complexType name="returnMerchantsCardsList"> <xs:sequence> <xs:element name="pageNumber" type="xs:int"/> <xs:element name="recordsPerPage" type="xs:int"/> </xs:sequence> </xs:complexType> <xs:complexType name="returnMerchantsCardsListResponse"> <xs:sequence> <xs:element maxOccurs="unbounded" minOccurs="0" name="return" type="ns1:stringArray"/> </xs:sequence> </xs:complexType> </xs:schema> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" targetNamespace="http://jaxb.dev.java.net/array" version="1.0"> <xs:complexType final="#all" name="stringArray"> <xs:sequence> <xs:element maxOccurs="unbounded" minOccurs="0" name="item" nillable="true" type="xs:string"/> </xs:sequence> </xs:complexType> </xs:schema> </wsdl:types> <wsdl:message name="returnMerchantsCardsList"> <wsdl:part element="tns:returnMerchantsCardsList" name="parameters"></wsdl:part> </wsdl:message> <wsdl:message name="returnMerchantsCardsListResponse"> <wsdl:part element="tns:returnMerchantsCardsListResponse" name="parameters"></wsdl:part> </wsdl:message> <wsdl:portType name="GetMerchantsCardsListInterface"> <wsdl:operation name="returnMerchantsCardsList"> <wsdl:input message="tns:returnMerchantsCardsList" name="returnMerchantsCardsList"></wsdl:input> <wsdl:output message="tns:returnMerchantsCardsListResponse" name="returnMerchantsCardsListResponse"></wsdl:output> </wsdl:operation> </wsdl:portType> <wsdl:binding name="GetMerchantsCardsList4SoapBinding" type="tns:GetMerchantsCardsListInterface"> <soap:binding style="document" transport="http://schemas.xmlsoap.org/soap/http"/> <wsdl:operation name="returnMerchantsCardsList"> <soap:operation soapAction="" style="document"/> <wsdl:input name="returnMerchantsCardsList"> <soap:body use="literal"/> </wsdl:input> <wsdl:output name="returnMerchantsCardsListResponse"> <soap:body use="literal"/> </wsdl:output> </wsdl:operation> </wsdl:binding> <wsdl:service name="GetMerchantsCardsList4"> <wsdl:port binding="tns:GetMerchantsCardsList4SoapBinding" name="GetMerchantsCardsList4Port"> <soap:address location="http://localhost:8080/webservices/test/SrvGetmerchantsCardsList.jsp"/> </wsdl:port> </wsdl:service> </wsdl:definitions>
I am using soapUI for testing. This is the request generated when I use soapUI :

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:shop="http://shoppingcart.abcd.com/"> <soapenv:Header/> <soapenv:Body><shop:returnMerchantsCardsList> <pageNumber>1</pageNumber> <recordsPerPage>4</recordsPerPage> </shop:returnMerchantsCardsList> </soapenv:Body> </soapenv:Envelope>

This is the response I get when I submit request to specified endpoint URL for the FIRST time:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <ns2:returnMerchantsCardsListResponse xmlns:ns2="http://shoppingcart.abcd.com/"> <return> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> </return> <return> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item>3</item> <item>Borders</item> <item>224</item> <item>jhgsjhdgjshgjjshsj</item> <item>25.00</item> <item>ord_mall.jpg</item> </return> <return> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item>5</item> <item>Gap</item> <item>210</item> <item>jhgsjhdgjshgjjshsj</item> <item>25.00</item> <item>land_mall.jpg</item> </return> <return> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item>6</item> <item>Fandango</item> <item>211</item> <item>jhgsjhdgjshgjjshsj</item> <item>25.00</item> <item>game_mall.jpg</item> </return> <return> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item>8</item> <item>AMC Theaters</item> <item>212</item> <item>jhgsjhdgjshgjjshsj</item> <item>25.00</item> <item>game_mall.jpg</item> </return> <return> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item>9</item> <item>Macy{#}s</item> <item>214</item> <item>jhgsjhdgjshgjjshsj</item> <item>25.00</item> <item>mac_mall.jpg</item> </return> <return> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item>10</item> <item>i-Tunes</item> <item>215</item> <item>jhgsjhdgjshgjjshsj</item> <item>25.00</item> <item>mac_mall.jpg</item> </return> </ns2:returnMerchantsCardsListResponse> </soap:Body> </soap:Envelope>
However when I resubmit request again I get following response everytime I submit request:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <ns2:returnMerchantsCardsListResponse xmlns:ns2="http://shoppingcart.abcd.com/"> <return> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> </return> <return> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> </return> <return> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> </return> <return> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> </return> <return> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> </return> <return> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> </return> <return> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> <item xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/> </return> </ns2:returnMerchantsCardsListResponse> </soap:Body> </soap:Envelope>

Actually I am expecting the same response when I submit request for the FIRST time. But somehow every time I submit request I get above response without any data. How to get rid of this?

Thank you.

Thanks Arun Kumar, Ivan Krizsan for your answers.

I am creating Apache CXF (apache-cxf-2.5.0) SOAP based Web Services. It creates WSDL from Java class (Java first approach). I have to use SOAP and can't use REST.

I am retrieving data from database using ResultSet. Data is about 5 columns and over 100 rows. Now I want to send this data to Android client. I am thinking of converting ResultSet into ArrayList and sending ArrayList / List object as a response from SOAP Web Service. My problem is - is it possible to send List object as a reponse from SOAP Web Service. If yes, please provide me link to such an examples.

Thank you.

Arun Kumar wrote:you can use jdbc/hibernate to get the data from database and pass it as POJO/String response via apache-cxf

Thanks Arun Kumar for your answer. I am new to Web Services. I am having three doubts:

1. If I want to send data as a String data, how to send that from the function (say sendData()) in my Java class as examples on the internet have shown sending only one String as a response?

2. Is it possible/OK to send/return POJO as a response?

3. If I want to send data as POJO, how client which is a Android application can know which type of data is this and retrieve data from POJO?

Thanks.

I am using Apache CXF (apache-cxf-2.5.0) to create Web Services using bottum up approach (Java first approach). I want to return some data / records (for example username, email) from a database table using web services created by bottum up approach (Java first approach). I can write Java class which returns single response. But I am not able to find way to return a response such as data / records (for example username, email) from a database table. How to do that?

Thanks.