Dear Sir,

I am again struck in my project.. i want to display data from oracle database but i get this error when i run the jsp file in tomcat, I post my code below.. kindly let me know what i am wrong!! kindly help me in this.

out.jsp

    <%@ page session="false"%> 
    <%@ page import="java.io.*" import="java.sql.*"%>
     <%try { 
    Connection con=null; 

    Class.forName("oracle.jdbc.driver.OracleDriver");

    Connection 
    con=DriverManager.getConnection("jdbc:oracle:thin:@//172.25.50.247:1521/knits", "ADMIN", "ADMIN");

    ps=con.prepareStatement("select * from departments");
     ResultSet rs= ps.executeQuery();
     while(rs.next()) 
    { 
    out.println(rs.getInt(name)); 
    out.println(rs.getString(id));
     } } catch(Exception e) {} 
    rs.close(); 
    ps.close();
    con.close(); %>

Error from apache tomcat 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: 9 in the jsp file: /jsp/test/form.jsp
Duplicate local variable con
6: Class.forName("oracle.jdbc.driver.OracleDriver");
7: 
8: Connection 
9: con=DriverManager.getConnection("jdbc:oracle:thin:@//172.25.50.247:1521/knits", "ADMIN", "ADMIN");
10: 
11: ps=con.prepareStatement("select * from departments");
12:  ResultSet rs= ps.executeQuery();

An error occurred at line: 11 in the jsp file: /jsp/test/form.jsp
ps cannot be resolved to a variable
8: Connection 
9: con=DriverManager.getConnection("jdbc:oracle:thin:@//172.25.50.247:1521/knits", "ADMIN", "ADMIN");
10: 
11: ps=con.prepareStatement("select * from departments");
12:  ResultSet rs= ps.executeQuery();
13:  while(rs.next()) 
14: { 

An error occurred at line: 12 in the jsp file: /jsp/test/form.jsp
ps cannot be resolved
9: con=DriverManager.getConnection("jdbc:oracle:thin:@//172.25.50.247:1521/knits", "ADMIN", "ADMIN");
10: 
11: ps=con.prepareStatement("select * from departments");
12:  ResultSet rs= ps.executeQuery();
13:  while(rs.next()) 
14: { 
15: out.println(rs.getInt(name)); 

An error occurred at line: 15 in the jsp file: /jsp/test/form.jsp
name cannot be resolved to a variable
12:  ResultSet rs= ps.executeQuery();
13:  while(rs.next()) 
14: { 
15: out.println(rs.getInt(name)); 
16: out.println(rs.getString(id));
17:  } } catch(Exception e) {} 
18: rs.close(); 

An error occurred at line: 16 in the jsp file: /jsp/test/form.jsp
id cannot be resolved to a variable
13:  while(rs.next()) 
14: { 
15: out.println(rs.getInt(name)); 
16: out.println(rs.getString(id));
17:  } } catch(Exception e) {} 
18: rs.close(); 
19: ps.close();

An error occurred at line: 18 in the jsp file: /jsp/test/form.jsp
rs cannot be resolved
15: out.println(rs.getInt(name)); 
16: out.println(rs.getString(id));
17:  } } catch(Exception e) {} 
18: rs.close(); 
19: ps.close();
20: con.close(); %>

An error occurred at line: 19 in the jsp file: /jsp/test/form.jsp
ps cannot be resolved
16: out.println(rs.getString(id));
17:  } } catch(Exception e) {} 
18: rs.close(); 
19: ps.close();
20: con.close(); %>

An error occurred at line: 20 in the jsp file: /jsp/test/form.jsp
con cannot be resolved
17:  } } catch(Exception e) {} 
18: rs.close(); 
19: ps.close();
20: con.close(); %>

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.