You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by pandrajula seshu srinivas <se...@rediffmail.com> on 2001/12/13 11:16:33 UTC
Error while executing jsp page (Urgent)
Hi,
While i am executing .JSP file in jakarta-tomcat4.0.1
it is giving the problem as follows. Please let me know the problem quickly.
JSP File
--------
<%@ page language="java" import="java.sql.*" %>
<html>
<head><title>Number Guess</title></head>
<body>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("Jdbc:Odbc:IMP");
if(con.isReadOnly()) con.setReadOnly(false);
Statement st=con.createStatement();
ResultSet rs = st.executeQuery("select * from [Sheet1$]");
//int rows = st.executeUpdate("INSERT INTO [Sheet1$](PART,Item) VALUES('7777-77','N7777-77')");
//int rows = st.executeUpdate("UPDATE [Sheet1$] SET PART = '8888-88' WHERE PART = '7777-77'");
//int rows = st.executeUpdate("DELETE FROM [Sheet1$]");
while(rs.next())
{
System.out.println("First value"+rs.getString(1));
}
//System.out.println("Rows inserted:"+rows);
con.commit();
con.close();
%>
</body>
</html>
ERROR While Executing the JSP file
-----------------------------------
A Servlet Exception Has Occurred
org.apache.jasper.JasperException: Unable to compile class for JSP if (pageContext != null) pageContext.handlePageException(t);
^
1 error
at org.apache.jasper.compiler.Compiler.compile(Unknown Source)
at org.apache.jasper.servlet.JspServlet.loadJSP(Unknown Source)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(Unknown Source)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(Unknown Source)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown Source)
at org.apache.jasper.servlet.JspServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
at org.apache.catalina.valves.CertificatesValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
at org.apache.catalina.valves.AccessLogValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.connector.http.HttpProcessor.process(Unknown Source)
at org.apache.catalina.connector.http.HttpProcessor.run(Unknown Source)
at java.lang.Thread.run(Thread.java:484)
Thanks,
Bye
Seshu Srinivas
-----------------------
IMKT Software Pvt. Ltd.,
Hyderabad.
INDIA.
Tel : 091-040-3379031/33
--
To unsubscribe: <ma...@jakarta.apache.org>
For additional commands: <ma...@jakarta.apache.org>
Troubles with the list: <ma...@jakarta.apache.org>
RE: Error while executing jsp page (Urgent)
Posted by Wouter Boers <li...@ikke.net>.
Try copying the code in a servlet and compile it, perhaps you get a better
idea of why it can't compile the code.
Wouter
-----Original Message-----
From: pandrajula seshu srinivas [mailto:seshusrinivas@rediffmail.com]
Sent: Thursday, 13 December, 2001 11:17
To: tomcat-user@jakarta.apache.org
Subject: Error while executing jsp page (Urgent)
Hi,
While i am executing .JSP file in jakarta-tomcat4.0.1
it is giving the problem as follows. Please let me know the problem quickly.
JSP File
--------
<%@ page language="java" import="java.sql.*" %>
<html>
<head><title>Number Guess</title></head>
<body>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("Jdbc:Odbc:IMP");
if(con.isReadOnly()) con.setReadOnly(false);
Statement st=con.createStatement();
ResultSet rs = st.executeQuery("select * from [Sheet1$]");
//int rows = st.executeUpdate("INSERT INTO [Sheet1$](PART,Item)
VALUES('7777-77','N7777-77')");
//int rows = st.executeUpdate("UPDATE [Sheet1$] SET PART = '8888-88' WHERE
PART = '7777-77'");
//int rows = st.executeUpdate("DELETE FROM [Sheet1$]");
while(rs.next())
{
System.out.println("First value"+rs.getString(1));
}
//System.out.println("Rows inserted:"+rows);
con.commit();
con.close();
%>
</body>
</html>
ERROR While Executing the JSP file
-----------------------------------
A Servlet Exception Has Occurred
org.apache.jasper.JasperException: Unable to compile class for JSP
if (pageContext != null) pageContext.handlePageException(t);
^
1 error
at org.apache.jasper.compiler.Compiler.compile(Unknown Source)
at org.apache.jasper.servlet.JspServlet.loadJSP(Unknown Source)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(Unkno
wn Source)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(Unknown
Source)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown Source)
at org.apache.jasper.servlet.JspServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown
Source)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
at org.apache.catalina.valves.CertificatesValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
at org.apache.catalina.valves.AccessLogValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.connector.http.HttpProcessor.process(Unknown Source)
at org.apache.catalina.connector.http.HttpProcessor.run(Unknown Source)
at java.lang.Thread.run(Thread.java:484)
Thanks,
Bye
Seshu Srinivas
-----------------------
IMKT Software Pvt. Ltd.,
Hyderabad.
INDIA.
Tel : 091-040-3379031/33
--
To unsubscribe: <ma...@jakarta.apache.org>
For additional commands: <ma...@jakarta.apache.org>
Troubles with the list: <ma...@jakarta.apache.org>
--
To unsubscribe: <ma...@jakarta.apache.org>
For additional commands: <ma...@jakarta.apache.org>
Troubles with the list: <ma...@jakarta.apache.org>