[bipien@yahoo.com]

Hello I am trying to connect with Oracle 9i through my jsp page in MyEclipse 6.0. I added ojdbc14.jar in build path in the project.I can access My table in oracle through DB Explorer of MyEclipse well.I can able to connect to database through same page with making dsn(type 1 ). Please help I am new to this forum.following is my jsp page
<%@ page import=”java.sql.*” %>
<%
String str=request.getParameter(“roll”);
try
{
PreparedStatement ps=conn.prepareStatement(“select name from BIPIN where roll=?”);
ps.setString(1,str);
ResultSet rs=ps.executeQuery();
while(rs.next())
{
out.print(“1.Your Name is : “+rs.getString(1));
}
rs.close();
conn.close();
}catch(Exception e)
{
e.printStackTrace();
out.println(e.getMessage());
}
%>
after running on tomcat server oracle.jdbc.driver.OracleDriver is desplayed on jsp page and following is erro message on console
INFO: Server startup in 5984 ms
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1359)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1205)
at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:128)
at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:66)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.apache.jsp.MyJsp_jsp._jspService(MyJsp_jsp.java:58)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Unknown Source)

[Loyal Water]

Please make sure your report has been deployed along with the project without any errors. When you run the report after deploying it, does it work fine?

[bipien@yahoo.com]

@support-nipun wrote:

Please make sure your report has been deployed along with the project without any errors. When you run the report after deploying it, does it work fine?

Yes my project work fine in tomcat 5.x , after deploying it and uncomment the commented part of my jsp coding and comment type 4 connectivity coding.
Thanks for reply.Please help I am waiting for ur reply

[Loyal Water]

Im not clear on what the problem is because your last reply sounds like everything is working fine?

[bipien@yahoo.com]

Sir,
I am able to connect now after 2 days of deliberation.Thanks for your help.Another Question is now I want to run a simple stateless EJB in my myeclipse ide.Can you sugest the step by step way with source code to deploy simple session ejb in myeclipseide and call it from web brouwser.I have Jboss,Java Sun apps and weblogic server.
I would be very greatfull to you.I
Thanks

[bipien@yahoo.com]

Sir,
I am able to connect now after 2 days of deliberation.Thanks for your help.Another Question is now I want to run a simple stateless EJB in my myeclipse ide.Can you sugest the step by step way with source code to deploy simple session ejb in myeclipseide and call it from web brouwser.I have Jboss,Java Sun apps and weblogic server.
I would be very greatfull to you.I
Thanks

[Loyal Water]

You can refer to this tutorial:-
http://www.myeclipseide.com/documentation/quickstarts/ejb3/

[Author]

Posts