'JSP/MYSQL Problem with TOMCAT'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       jetspeed-user
Subject:    JSP/MYSQL Problem with TOMCAT
From:       Anthony Smith <anthony.smith () fedex ! com>
Date:       2001-07-30 18:56:49
[Download RAW message or body]

When I try to display this page in any other directory besides Jetspeed in TOMCAT
it works fine, but when I load the page in Jetspeed, I get this error:

The code is listed below

Error: 500
Location: /jetspeed/t.jsp
Internal Servlet Error:

javax.servlet.ServletException: After end of result set
 at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:459)

 at _0002ft_0002ejspt_jsp_26._jspService(_0002ft_0002ejspt_jsp_26.java:130)
 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at
org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.java:130)

 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:282)

 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
 at org.apache.tomcat.core.Handler.service(Handler.java:287)
 at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
 at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)

 at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
 at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)

 at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
 at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
 at java.lang.Thread.run(Thread.java:484)

Root cause:
java.sql.SQLException: After end of result set
 at org.gjt.mm.mysql.ResultSet.checkRowPos(ResultSet.java:1340)
 at org.gjt.mm.mysql.ResultSet.getString(ResultSet.java:220)
 at org.gjt.mm.mysql.ResultSet.getString(ResultSet.java:889)
 at _0002ft_0002ejspt_jsp_26._jspService(_0002ft_0002ejspt_jsp_26.java:100)
 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at
org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.java:130)

 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:282)

 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
 at org.apache.tomcat.core.Handler.service(Handler.java:287)
 at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
 at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)

 at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
 at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)

 at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
 at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
 at java.lang.Thread.run(Thread.java:484)

*****************************************************************************
<%@ page import="java.sql.*" %>
<%
 String connectionURL =

"jdbc:mysql://localhost:3306/portal?user=root;password=your_password";
                       Connection connection = null;
                       Statement statement = null;
ResultSet menu = null;
ResultSet links = null;
%>
<html><body>
<%
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "", "");
statement = connection.createStatement();
menu = statement.executeQuery("SELECT * FROM menu");
int group_id = 5000;
while (menu.next()) {
 //String sql="SET @current_menu:=" + ;
 //statement.executeQuery(sql);
 links = statement.executeQuery("SELECT * FROM links WHERE MENU =" +
 "\"" + menu.getString("MENU_NAME") + "\"" +  " AND " + "GROUP_ID = " + "\"" +
group_id + "\"");
 out.println("<b>" +  menu.getString("MENU_NAME")+"<br>" +"</b>" );
 while (links.next()) {
  out.println(links.getString("LINK_NAME")+"<br>");
 }
}
menu.close();
links.close();
%>
</body></html>


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-user-help@jakarta.apache.org

[prev in list] [next in list] [prev in thread] [next in thread]
Configure | About | News | Add a list | Sponsored by KoreLogic