java script unable to connect to oracle database and insert data

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.

View Answers

September 13, 2012 at 1:33 PM

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.

September 14, 2012 at 10:10 AM

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"); %>

September 14, 2012 at 3:37 PM

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");
    %>

September 15, 2012 at 10:43 AM

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.