Yes, probably it is hard to serialize ResultSet. You need to use something like data services for this.
Deepal > Hello, > > Can I not return Resultset as a return type from my Java class(Server.) > > > > I am getting error with following response. > > > > > > *-* > <http://127.0.0.1:50669/wse/wsdl/soap_envelope_xml.jsp?soapEnvelopeType=1> > <soapenv:Envelopexmlns:soapenv="*http://schemas.xmlsoap.org/soap/envelope/*";> > > *-* > <http://127.0.0.1:50669/wse/wsdl/soap_envelope_xml.jsp?soapEnvelopeType=1> > <soapenv:Body> > > *-* > <http://127.0.0.1:50669/wse/wsdl/soap_envelope_xml.jsp?soapEnvelopeType=1> > <soapenv:Fault> > > <faultcode>soapenv:Server</faultcode> > > <faultstring>org.apache.axis2.AxisFault: Mapping qname not fond for > the package: com.mysql.jdbc</faultstring> > > <detail /> > > </soapenv:Fault> > > </soapenv:Body> > > </soapenv:Envelope> > > > > If yes please let me know: > > > > Java Class I have commented code using ArrayList, ArrayList worked > fine for me but I should not use it so: > > package sdsdd; > > > > import java.sql.*; > > import java.util.ArrayList; > > import java.util.List; > > > > public class add { > > > > public ResultSet res(String group){ > > Connection con; > > List result = null; > > String query; > > ResultSet rs=null; > > ArrayList<Object> arr=new > ArrayList<Object>(); > > try { > > > > > > Class.forName("com.mysql.jdbc.Driver"); > > String url = "jdbc:mysql://localhost:3306/test"; > > con = DriverManager.getConnection(url, "root", "abcd1234"); > > Statement st = con.createStatement(); > > query="select * from detail where group1='"+ group + "'"; > > rs = st.executeQuery(query); > > ResultSetMetaData col=rs.getMetaData(); > > int numCol=col.getColumnCount(); > > System.out.println(numCol); > > while(rs.next()) > > { > > //ArrayList<Object> l=new ArrayList<Object>(); > > // > > // > > // l.add(rs.getInt(1)); > > // l.add(rs.getString(2)); > > // l.add(rs.getString(3)); > > // > > // > > // > > // arr.addAll(l); > > rs.getInt(1); > > } > > > > > > > > } catch > (ClassNotFoundException e) { > > // > TODO Auto-generated catch block > > > e.printStackTrace(); > > } catch (SQLException e) { > > // > TODO Auto-generated catch block > > > e.printStackTrace(); > > } > > return rs; > > } > > > > } > > > > > > > > If not which is the best possible way to return a resultset. >
