Hello Everyone,
I am new to jsp and servers.. my first project given to me is to insert data from jsp to oracle database 8, so i create a table in oracle departments and two coloum name depaermentname and departmentid, i found this below jsp coding in rose india for sql and i changed the drivers for oracle.. when i try to run the jsp file from tomcat i get this error.. let me know what i am doing wrong.. and is there is any driver i need to download?
please help me to start my project, i am struggled in this.
insert.jsp
<%@page import="java.sql.*"%> <% String name=request.getParameter("department_name"); String address=request.getParameter("department_id"); Class.forName("oracle.jdbc.driver.OracleDriver") con=DriverManager.getConnection("jdbc:oracle:thin://172.25.50.247:1521/knits", "ADMIN", "ADMIN"); Statement st=con.createStatement(); int i=st.executeUpdate("insert into departments(department_name,department_id) values('"+department_name+"','"+department_id+"')"); out.println("Data is inserted successfully"); %>
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 5 in the jsp file: /jsp/insert.jsp Syntax error, insert ";" to complete Statement 2: <% 3: String name=request.getParameter("department_name"); 4: String address=request.getParameter("department_id"); 5: Class.forName("oracle.jdbc.driver.OracleDriver") 6: con=DriverManager.getConnection("jdbc:oracle:thin://localhost:1521/knits", "ADMIN", "ADMIN"); 7: Statement st=con.createStatement(); 8: int i=st.executeUpdate("insert into departments(department_name,department_id) values('"+department_name+"','"+department_id+"')"); An error occurred at line: 6 in the jsp file: /jsp/insert.jsp con cannot be resolved to a variable 3: String name=request.getParameter("department_name"); 4: String address=request.getParameter("department_id"); 5: Class.forName("oracle.jdbc.driver.OracleDriver") 6: con=DriverManager.getConnection("jdbc:oracle:thin://localhost:1521/knits", "ADMIN", "ADMIN"); 7: Statement st=con.createStatement(); 8: int i=st.executeUpdate("insert into departments(department_name,department_id) values('"+department_name+"','"+department_id+"')"); 9: out.println("Data is inserted successfully"); An error occurred at line: 7 in the jsp file: /jsp/insert.jsp con cannot be resolved 4: String address=request.getParameter("department_id"); 5: Class.forName("oracle.jdbc.driver.OracleDriver") 6: con=DriverManager.getConnection("jdbc:oracle:thin://localhost:1521/knits", "ADMIN", "ADMIN"); 7: Statement st=con.createStatement(); 8: int i=st.executeUpdate("insert into departments(department_name,department_id) values('"+department_name+"','"+department_id+"')"); 9: out.println("Data is inserted successfully"); 10: %> An error occurred at line: 8 in the jsp file: /jsp/insert.jsp department_name cannot be resolved to a variable 5: Class.forName("oracle.jdbc.driver.OracleDriver") 6: con=DriverManager.getConnection("jdbc:oracle:thin://localhost:1521/knits", "ADMIN", "ADMIN"); 7: Statement st=con.createStatement(); 8: int i=st.executeUpdate("insert into departments(department_name,department_id) values('"+department_name+"','"+department_id+"')"); 9: out.println("Data is inserted successfully"); 10: %> 11: An error occurred at line: 8 in the jsp file: /jsp/insert.jsp department_id cannot be resolved to a variable 5: Class.forName("oracle.jdbc.driver.OracleDriver") 6: con=DriverManager.getConnection("jdbc:oracle:thin://localhost:1521/knits", "ADMIN", "ADMIN"); 7: Statement st=con.createStatement(); 8: int i=st.executeUpdate("insert into departments(department_name,department_id) values('"+department_name+"','"+department_id+"')"); 9: out.println("Data is inserted successfully"); 10: %> 11: Stacktrace: org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92) org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330) org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:439) org.apache.jasper.compiler.Compiler.compile(Compiler.java:356) org.apache.jasper.compiler.Compiler.compile(Compiler.java:334) org.apache.jasper.compiler.Compiler.compile(Compiler.java:321) org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:592) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.35 logs.
Another error
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception org.apache.jasper.JasperException: org.apache.jasper.JasperException: Unable to load class for JSP org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:161) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:340) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) root cause org.apache.jasper.JasperException: Unable to load class for JSP org.apache.jasper.JspCompilationContext.load(JspCompilationContext.java:630) org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:149) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:340) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) root cause java.lang.ClassNotFoundException: org.apache.jsp.jsp.insert_jsp java.net.URLClassLoader$1.run(Unknown Source) java.security.AccessController.doPrivileged(Native Method) java.net.URLClassLoader.findClass(Unknown Source) org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:134) org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:66) org.apache.jasper.JspCompilationContext.load(JspCompilationContext.java:628) org.apache.jasper.servlet.JspServletWrapper.getServlet(JspServletWrapper.java:149) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:340) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.35 logs.
Post your code. The error lies in your code. It seems that you haven't imported the package which is needed or having some syntax error. So overall, the problem is in your code. So send it.
Thanks for your reply.. the coding is all follows
This is my Html coding
<html> <form method="post" action="http://localhost:8080/examples/jsp/insert.jsp"> <table> <tr><td>Department_Name:</td><td><input type="text" name="Department_Name"></td></tr> <tr><td>Department_ID:</td><td><input type="text" name="Department_ID"></td></tr> <tr><td></td><td><input type="submit" value="Submit"></td></tr> </table> </form> </html>
This is my jsp code
<%@page import="java.sql.*"%> <% String name=request.getParameter("department_name"); String address=request.getParameter("department_id");
Class.forName("oracle.jdbc.driver.OracleDriver")
con=DriverManager.getConnection("jdbc:oracle:thin://172.25.50.247:1521/knits", "ADMIN", "ADMIN");
Statement st=con.createStatement();
int i=st.executeUpdate("insert into departments(departmentname,departmentid) values('"+departmentname+"','"+departmentid+"')"); out.println("Data is inserted successfully"); %>
We have modified your insert.jsp file. It was having some errors. Your html file is ok. insert.jsp:
<%@page import="java.sql.*"%> <% String name=request.getParameter("Department_Name"); String id=request.getParameter("Department_ID"); Class.forName("oracle.jdbc.driver.OracleDriver") Connection con=DriverManager.getConnection("jdbc:oracle:thin://172.25.50.247:1521/knits", "ADMIN", "ADMIN"); Statement st=con.createStatement(); int i=st.executeUpdate("insert into departments(departmentname,departmentid) values('"+name+"','"+id+"')"); out.println("Data is inserted successfully"); %>
Thanks for your reply and codings.. when i try to compile and run the insert.jsp in jdeveloper i got the below error.. and still i struck here..i am using oracle 10g and my database is 8i which i need to conect.. and also i post the error that i got from tomcat now.. what i need to do..
**Error from Jdeveloper** 500 Internal Server Error java.sql.SQLException: Io exception: The Network Adapter could not establish the connection at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:286) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:327) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:433) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:150) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at _23._jspService(23.jsp:9) [/23.jsp] at com.orionserver[Oracle Application Server Containers for J2EE 10g (10.1.2.0.2)].http.OrionHttpJspPage.service(OrionHttpJspPage.java:57) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:350) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.2)].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65) at oracle.security.jazn.oc4j.JAZNFilter.doFilter(Unknown Source) at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.2)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:663) at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.2)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:330) at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.2)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:830) at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.2)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:285) at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.2)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:126) at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.2)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192) at java.lang.Thread.run(Thread.java:534) **Error from Tomcat** 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 /jsp/rose/insert.jsp at line 8 5: 6: Class.forName("oracle.jdbc.driver.OracleDriver"); 7: 8: Connection con=DriverManager.getConnection("jdbc:oracle:thin://172.25.50.247:1521/knits", "ADMIN", "ADMIN"); 9: 10: Statement st=con.createStatement(); 11: Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:521) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:412) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) root cause javax.servlet.ServletException: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:865) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:794) org.apache.jsp.jsp.rose.insert_jsp._jspService(insert_jsp.java:75) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) root cause java.sql.SQLException: Io exception: The Network Adapter could not establish the connection oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147) oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257) oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:389) oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:454) oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165) oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:802) java.sql.DriverManager.getConnection(Unknown Source) java.sql.DriverManager.getConnection(Unknown Source) org.apache.jsp.jsp.rose.insert_jsp._jspService(insert_jsp.java:63) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) note The full stack trace of the root cause is available in the Apache Tomcat/6.0.35 logs.