Someone Plz help me, URGENT:
is there any thing wrong with this JSP code :
file name: login1.jsp:
<%@ page language="java" import="java.sql.*" %>
<%java.sql.Connection conn=null;
try {
javax.naming.Context ctx = new javax.naming.InitialContext();
javax.sql.Datasource ds = (javax.sql.DataSource)ctx.lookup("jdbc/DB2DS");
conn = ds.getConnection();
java.sql.Satement stmt = conn.createStaement();
java.sql.ResultSet rs = stmt.executeQuery("Select * from login");
while (rs.next()){
out.println(rs.getString("LOGID"));
out.println(rs.getString("PWD"));
}
rs.close();
stmt.close();
}catch (Exception e){
System.out.println("Service Error: "+e);
}finally {
if (conn !=null)
try {
conn.close();
} catch (Exception ignore) {};
}
%>
when I run it, the errors page it throws is:
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: Unable to compile class for JSP
An error occurred at line: 6 in the jsp file: /login1.jsp
Generated servlet error:
C:\Migrations\jboss-3.2.5\server\default\work\jboss.web\localhost\MyGreeting6\org\apache\jsp\login1_jsp.java:52:
cannot resolve symbol
symbol : class Datasource
location: package sql
javax.sql.Datasource ds = (javax.sql.DataSource)ctx.lookup("jdbc/DB2DS");
^
An error occurred at line: 6 in the jsp file: /login1.jsp
Generated servlet error:
C:\Migrations\jboss-3.2.5\server\default\work\jboss.web\localhost\MyGreeting6\org\apache\jsp\login1_jsp.java:55:
cannot resolve symbol
symbol : class Satement
location: package sql
java.sql.Satement stmt = conn.createStaement();
^
An error occurred at line: 6 in the jsp file: /login1.jsp
Generated servlet error:
C:\Migrations\jboss-3.2.5\server\default\work\jboss.web\localhost\MyGreeting6\org\apache\jsp\login1_jsp.java:55:
cannot resolve symbol
symbol : method createStaement ()
location: interface java.sql.Connection
java.sql.Satement stmt = conn.createStaement();
^
3 errors
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:412)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:472)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.26
logs.
--------------------------------------------------------------------------------
Apache Tomcat/5.0.26
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3843460#3843460
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3843460
-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop
FREE Java Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
_______________________________________________
JBoss-Development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
