It's URGENTProblem with xdb.jar

i have copied the jar in the specific lib but still the error is coming.

mport 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..

Partha_Olimmsa at 2007-7-14 21:13:56 >