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.