Thanks. I found that it was really a JBoss (J2EE server) specific error. It's solved now.
Regards, Lee -----Original Message----- From: Srinath Perera [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 3:07 PM To: [EMAIL PROTECTED] Subject: Re: Trouble connecting web service in Axis to Oracle DB dear Chen, Li Am not sure about the oracle exception. one simple things you can try is to try to deploy the service with a wsdd(if need more info look at axis user guide) file rather than using .jws. I grant you nothing. But i feel it worth a try.(when you use the jws it has certain limitaions) regards Srinath On Wed, 2003-07-02 at 18:28, Chen, Li (Research, YOH) wrote: > Hi all, > Here is a peculiar situation that I am trying to resolve: I am > trying to deploy a simple web service that would connect in a "chain" > fashion to the back-end JDBC-Oracle connection class and retreive data from > the Oracle database. The "client" sees a simple JWS file as the endpoint > URL, and calls one of the JWS's methods. The method then calls a some other > classes, each which does its work and eventually the JDBC-Oracle class is > executed and result from the Oracle DB is pulled. However, I have this > mysterious error -- when I send from one of the "client" to a request to the > JWS web service file, I see the following error message as intercepted by > TCPMonitor: > > HTTP/1.1 500 Internal Server Error > Date: Wed, 02 Jul 2003 12:07:41 GMT > Server: Jetty/4.2.9 (Windows 2000/5.0 x86 java/1.4.1_02) > Set-Cookie: JSESSIONID=51m56qekkr93f;Path=/spoda > Set-Cookie2: JSESSIONID=51m56qekkr93f;Version=1;Path=/spoda;Discard > Content-Type: text/xml; charset=utf-8 > > <?xml version="1.0" encoding="UTF-8"?> > <SOAP-ENV:Envelope > xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"; > xmlns:xsd="http://www.w3.org/2001/XMLSchema"; > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> > <SOAP-ENV:Body> > <SOAP-ENV:Fault> > <SOAP-ENV:faultcode > xmlns:ns4="http://xml.apache.org/axis/";>ns4:Server.generalException</SOAP-EN > V:faultcode> > <SOAP-ENV:faultstring>java.lang.reflect.InvocationTargetException > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39 > ) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl > .java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:2 > 20) > at > org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:244) > > at > org.apache.axis.handlers.JWSProcessor.invokeImpl(JWSProcessor.java:227) > > at > org.apache.axis.handlers.JWSProcessor.invoke(JWSProcessor.java:99) > at > org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:232) > at org.apache.axis.server.AxisServer.invoke(AxisServer.java:262) > > at > org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:338) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > at > org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:360) > at > org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandl > er.java:294) > at > org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:558) > > at org.mortbay.http.HttpContext.handle(HttpContext.java:1714) > at > org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext > .java:507) > at org.mortbay.http.HttpContext.handle(HttpContext.java:1664) > at org.mortbay.http.HttpServer.service(HttpServer.java:863) > at org.jboss.jetty.Jetty.service(Jetty.java:460) > at org.mortbay.http.HttpConnection.service(HttpConnection.java:775) > > at > org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:939) > at org.mortbay.http.HttpConnection.handle(HttpConnection.java:792) > > at > org.mortbay.http.SocketListener.handleConnection(SocketListener.java:201) > > at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:289) > > at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:455) > Caused by: java.lang.NoClassDefFoundError: > oracle/jdbc/driver/OracleDriver > at CCR_Connection.<init>(CCR_Connection.java:38) > at Converter.grabData(Converter.java:60) > at Spoda.getPersonData(Spoda.java:64) ... 27 more \ > </SOAP-ENV:faultstring> > </SOAP-ENV:Fault> > </SOAP-ENV:Body> > </SOAP-ENV:Envelope> > > This Caused by: java.lang.NoClassDefFoundError: > oracle/jdbc/driver/OracleDriver seems to be the cause of the error. However, > I can't figure out why tha happens: when I rename the JWS file as a Java > file and execute a "request" on the server side (i.e. pass all my parameters > on the "server" side to the Java file), it works perfectly. And yes, I have > included the JDBC-Oracle drivers in the classpath. I am using: > > JBoss 3.2.1 with Jetty > Axis 1.1RC2 > Oracle 8i (8.1.7.0.0) > > Any insights into this? > > Thanks!! > > Lee >
