help:OracleXMLQuery exception

来源:互联网 发布:饿了么配送费 知乎 编辑:程序博客网 时间:2024/06/08 06:30

Here is my code jsp page:

 

Connection con = null;

String sql = "select * from aff_users where aff_id = 463740";

con = getConnection();

OracleXMLQuery query = new OracleXMLQuery(con,sql);

String xmlString = query.getXMLString();

out.println(xmlString);

 

 my jdk is 1.5

 oracle driver is ojdbc6.jar 

 xsu12.jar

 

Here is the exception:

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: tried to access class oracle.jdbc.driver.OracleResultSet from class oracle.xml.sql.core.OracleXMLConvert
 org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460)
 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:803)


root cause

javax.servlet.ServletException: tried to access class oracle.jdbc.driver.OracleResultSet from class oracle.xml.sql.core.OracleXMLConvert
 org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:841)
 org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:774)
 org.apache.jsp.aff_005fgetdatafeeds_jsp._jspService(aff_005fgetdatafeeds_jsp.java:722)
 org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:803)


root cause

java.lang.IllegalAccessError: tried to access class oracle.jdbc.driver.OracleResultSet from class oracle.xml.sql.core.OracleXMLConvert
 oracle.xml.sql.core.OracleXMLConvert.initObject(OracleXMLConvert.java:360)
 oracle.xml.sql.core.OracleXMLConvert.getXML(OracleXMLConvert.java:841)
 oracle.xml.sql.query.OracleXMLQuery.getXMLString(OracleXMLQuery.java:277)
 oracle.xml.sql.query.OracleXMLQuery.getXMLString(OracleXMLQuery.java:225)
 oracle.xml.sql.query.OracleXMLQuery.getXMLString(OracleXMLQuery.java:202)
 com.wm.affnet.dao.AffUsersDao.getUserXML(AffUsersDao.java:857)
 com.wm.affnet.AffDBPackage.getDownload(AffDBPackage.java:310)
 org.apache.jsp.aff_005fgetdatafeeds_jsp._jspService(aff_005fgetdatafeeds_jsp.java:136)
 org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
 org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
 org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
 org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
 javax.servlet.http.HttpServlet.service(HttpServlet.java:803)


note The full stack trace of the root cause is available in the Apache Tomcat/5.5.26 logs.