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: Exception in JSP: /topic/product/index.jsp:37

34: 						<a class="tt" href="list.jsp?code=001" target="_blank">�����</a>
35: 					</div>
36: 					<div style="width: 150px; height: 87px; padding: 0; font-size: 12px; float: right;">
37: 					<%sql="select category_name,`code` from 2010cbiit_category where parent_id=1 and 2011_show=1";rs=stmt.executeQuery(sql);while(rs.next()){%>
38: 						<div class=list1><a class="listname" href="list.jsp?code=<%=rs.getString("code")%>" target="_blank"><%=rs.getString("category_name")%></a></div>
39: 					<%} %>	
40: 					</div>


Stacktrace:
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:451)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

javax.servlet.ServletException: Table 'cbinewsnews.2010cbiit_category' doesn't exist
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:841)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:774)
	org.apache.jsp.topic.product.index_jsp._jspService(index_jsp.java:587)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

java.sql.SQLException: Table 'cbinewsnews.2010cbiit_category' doesn't exist
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
	com.mysql.jdbc.Connection.execSQL(Connection.java:3020)
	com.mysql.jdbc.Connection.execSQL(Connection.java:2949)
	com.mysql.jdbc.Statement.executeQuery(Statement.java:959)
	sun.reflect.GeneratedMethodAccessor41.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	java.lang.reflect.Method.invoke(Method.java:597)
	org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
	org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
	$java.sql.Statement$$EnhancerByProxool$$7510231.executeQuery(<generated>)
	org.apache.jsp.topic.product.index_jsp._jspService(index_jsp.java:85)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.26 logs.


Apache Tomcat/5.5.26