Re: Trouble connecting web service in Axis to Oracle DB

[ian_d_stewart]

Most of the operations in the java.sql package throw SQLExceptions.  You
need to catch those exceptions and raise a wrapped AxisFault.

Example:

try {
    .
    .
    .
}
catch (SQLException sqle) {
    throw AxisFault.makeFault(sqle);
}


HTH,
Ian

Ian D. Stewart
Open Systems Engineer II
Enterprise Midrange - Bank One Infrastructure & Operations
[EMAIL PROTECTED]
(614) 213-6100




"Chen, Li (Research, YOH)" <[EMAIL PROTECTED]> on 07/02/2003 08:28:48
AM

Please respond to [EMAIL PROTECTED]

To:   "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
cc:

Subject:  Trouble connecting web service in Axis to Oracle DB



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
Content-Length: 2715

<?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.&lt;init&gt;(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








This transmission may contain information that is privileged, confidential and/or 
exempt from disclosure under applicable law. If you are not the intended recipient, 
you are hereby notified that any disclosure, copying, distribution, or use of the 
information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. 
If you received this transmission in error, please immediately contact the sender and 
destroy the material in its entirety, whether in electronic or hard copy format. Thank 
you.