URGENT!!Error Creating XML file.....
import oracle.jdbc.driver.*;
import oracle.xml.sql.query.OracleXMLQuery;
import java.lang.*;
import java.sql.*;
public String createXML1(int docid,String keyvalue)
{
String SQL="select * from T_STO_STORES_DIVERSION where NU_DIVERSION_REQ_NO="+keyvalue;
//SQL="select NU_LOC_ID,VC_LOC_DESC,NU_LOC_GROUP_ID,to_char(DT_MODIFIED_DATE,'dd/mm/yyyy') DT_MODIFIED_DATE from t_adm_location where nu_loc_id="+keyvalue;
OracleXMLQuery qry = new OracleXMLQuery(conn,SQL);
qry.setRowsetTag("RECORDS");
qry.setRowTag("DOCUMENT");
qry.setRowIdAttrName("SLNo");
String str = qry.getXMLString();
qry.close();
return str;
}
when i am running it from editor it's running well but when i am calling it from the jsp page it's giving some error in this line
OracleXMLQuery qry = new OracleXMLQuery(conn,SQL);
the error is like this
java.lang.NoClassDefFoundError: oracle/xml/parser/v2/XSLException
at DeletedRecords.createXML1(DeletedRecords.java:35)
at /stores/scr_Req_Diversion_Action.jsp._jspService(/stores/scr_Req_Diversion_Action.jsp.java:297) (JSP page line 248)
at com.orionserver[Oracle9iAS (1.0.2.2) Containers for J2EE].http.OrionHttpJspPage.service(OrionHttpJspPage.java:54)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].server.http.HttpApplication.serviceJSP(HttpApplication.java:5458)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].server.http.JSPServlet.service(JSPServlet.java:31)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:501)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:170)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:576)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].server.http.HttpRequestHandler.run(HttpRequestHandler.java:189)
at com.evermind[Oracle9iAS (1.0.2.2) Containers for J2EE].util.ThreadPoolThread.run(ThreadPoolThread.java:62)
what is the problem...pl. suggest me what to do..
