RE: returning a resultset

[Newman, Scott]

Ah, I see.  No big deal.  Thanks for the answer. Newman   -----Original Message----- From: Walden Mathews [mailto:[EMAIL PROTECTED]] Sent: 03 April, 2002 11:55 AM To: '[EMAIL PROTECTED]' Subject: RE: returning a resultset   A ResultSet contains a connection so that you can update the database through it. That connection makes the RS "not serializable", so it's illegal to send it across the net no matter what protocol you use. -----Original Message----- From: Newman, Scott [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 10:32 AM To: [EMAIL PROTECTED] Subject: returning a resultset Hi all   I just want to know if it is possible to return a resultset from a web service.  I'm trying it now, but I keep coming up with:   java.io.IOException: No serializer found for class sun.jdbc.odbc.JdbcOdbcResultSet in registry org.apache.axis.encoding.SerializationContextImpl@3d09e8 java.io.IOException: No serializer found for class sun.jdbc.odbc.JdbcOdbcResultSet in registry org.apache.axis.encoding.SerializationContextImpl@3d09e8             at org.apache.axis.encoding.SerializationContextImpl.serializeActual(Unknown Source)             at org.apache.axis.encoding.SerializationContextImpl.serialize(Unknown Source)             at org.apache.axis.encoding.SerializationContextImpl.outputMultiRefs(Unknown Source)             at org.apache.axis.message.SOAPEnvelope.outputImpl(Unknown Source)             at org.apache.axis.message.MessageElement.output(Unknown Source)             at org.apache.axis.SOAPPart.getAsString(Unknown Source)             at org.apache.axis.SOAPPart.getAsBytes(Unknown Source)             at org.apache.axis.Message.getContentType(Unknown Source)             at org.apache.axis.transport.http.AxisServlet.doPost(Unknown Source)             at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)             at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)             at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)             at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)             at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)             at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)             at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)             at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)             at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)             at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)             at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)             at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)             at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)             at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)             at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)             at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)             at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)             at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)             at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)             at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)             at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)             at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)             at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)             at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)             at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)             at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)             at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)             at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012)             at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107)             at java.lang.Thread.run(Thread.java:484) I just thought that this would be a common use for SOAP, but if not, no biggie.  J Newman