Вот кусок кода | Код |
<%
Statement st = mysqlcon.GetStatement();
String sql1 = "select ConversationID,ConversationTopic,Subject "+
"from messages "+
"group by ConversationID";
ResultSet res1 = st.executeQuery(sql1);
while(res1.next()) {
String s = res1.getString("ConversationID");
%>
<li class="Node ExpandClosed">
<div class="Expand"></div>
<div class="Content"><%= res1.getString("ConversationTopic") %></div>
<%
String sql2 = "select ConversationID,Subject "+
"from messages "+
"where ConversationID='"+s+"'";
ResultSet res2 = st.executeQuery(sql2);
%>
<ul class="Container">
<li class="Node ExpandLeaf">
<%while(res2.next()) { %>
<div class="Expand"></div>
<div class="Content"><a href="#"><%= res2.getString("Subject") %></a></div>
<% }; %>
</li>
</ul>
</li>
<%
};
%>
|
Вроде все правильно , но непонятно ругается | Код |
org.apache.jasper.JasperException: An exception occurred processing JSP page /index.jsp at line 67
64: "from messages "+
65: "group by ConversationID";
66: ResultSet res1 = st.executeQuery(sql1);
67: while(res1.next()) {
68: String s = res1.getString("ConversationID");
69: %>
70: <li class="Node ExpandClosed">
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:567)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:456)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
root cause
javax.servlet.ServletException: java.sql.SQLException: Operation not allowed after ResultSet closed
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:911)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:840)
org.apache.jsp.index_jsp._jspService(index_jsp.java:199)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:433)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
root cause
java.sql.SQLException: Operation not allowed after ResultSet closed
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:794)
com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7139)
org.apache.jsp.index_jsp._jspService(index_jsp.java:141)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:433)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
|
|
Ошибка в запросах 
Загрузка ...
