I get an error when i execute the following code :
<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <title>SaveNames</title> </head> <body> <%@page import="java.sql.*" %> <%@page import="javax.servlet.http.*" %> <%@page import="javax.servlet.jsp.*" %> <% String firstname = request.getParameter("first"); String lastname = request.getParameter("last"); Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1522:XE","hr","hr"); String query = "insert into name(firstname,lastname) values(?,?)" ; Statement st = con.createStatement(); st.executeQuery(query); %> <jsp:forward page="address.jsp"></jsp:forward> 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: An exception occurred processing JSP page /savedetails.jsp at line 18 15: String firstname = request.getParameter("first"); 16: String lastname = request.getParameter("last"); 17: 18: Class.forName("oracle.jdbc.driver.OracleDriver"); 19: Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1522:XE","hr","hr"); 20: String query = "insert into name(firstname,lastname) values(?,?)" ; 21: Statement st = con.createStatement(); Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:568) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:455) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) javax.servlet.http.HttpServlet.service(HttpServlet.java:722) root cause javax.servlet.ServletException: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:911) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:840) org.apache.jsp.savedetails_jsp._jspService(savedetails_jsp.java:102) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:722) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) javax.servlet.http.HttpServlet.service(HttpServlet.java:722) root cause java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1688) org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1533) org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:126) org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:63) java.lang.Class.forName0(Native Method) java.lang.Class.forName(Unknown Source) org.apache.jsp.savedetails_jsp._jspService(savedetails_jsp.java:81) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:722) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) javax.servlet.http.HttpServlet.service(HttpServlet.java:722) note The full stack trace of the root cause is available in the Apache Tomcat/7.0.23 logs. Apache Tomcat/7.0.23 </body> </html>
Explore ojdbc14.jar or classes12.jar whether it has oracle.jdbc.driver.OracleDriver or not. If the jar is having that class, then there may be environment problems and need to revisit before you test with the app.
Ya i have the driver but still i am getting the error.....Environment problems ?? What i need to check ??
I am using Eclipse Indigo IDE and before deploying the project i build the path by adding external jars of ojdbc14.jar . But when i do the following code its getting connected to database
import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException;
public class Connected {
/** * @param args * @throws ClassNotFoundException * @throws SQLException */ public static void main(String[] args) throws ClassNotFoundException, SQLException { // TODO Auto-generated method stub Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1522:XE", "hr", "hr"); System.out.println("connected successfully"); }
}
Output: connected successfully.
So when using web app only i am unable to connect the database.