Dear all,
Please tell me why if the result is no record, then the following error
message display ? How can I solve it.
Thanks.
<%@ page language="java" import="java.sql.*,java.io.*" %>
<%!
Connection con=null;
Statement stmt=null;
ResultSet result=null;
Statement stmt1=null;
ResultSet result_Category;
Statement stmt2=null;
ResultSet result_MemoryCode;
Statement stmt3=null;
ResultSet result_Brand_Name=null;
Statement stmt4=null;
ResultSet result_Supplier=null;
// Initialize the connection
public void jspInit() {
try {
DriverManager.registerDriver( new oracle.jdbc.driver.OracleDriver()
);
con=DriverManager.getConnection("jdbc:oracle:thin:
@192.168.0.253:1521:aft", "system", "manager" );
stmt=con.createStatement();
stmt1=con.createStatement();
stmt2=con.createStatement();
stmt3=con.createStatement();
stmt4=con.createStatement();
} catch (Exception e) {
System.out.println( e.toString() );
}
}
public void jspDestroy() {
try {
result.close();
result_Category.close();
result_MemoryCode.close();
result_Brand_Name.close();
result_Supplier.close();
stmt.close();
stmt1.close();
stmt2.close();
stmt3.close();
stmt4.close();
con.close();
} catch (Exception e) {
System.out.println( e.toString() );
}
}
%>
<%
try {
//Item Master
String itcode=request.getParameter("itemcode");
result=stmt.executeQuery("Select * from dick.Item_Master where
ITEMCODE = '" + itcode + "'");
if ( result.next() ) {
System.out.println("Access");
//Category Master
result_Category=stmt1.executeQuery("Select * from
dick.Category_Master where category = " + "'" + result.getString
("Category") + "'");
result_Category.next();
//Memory Code Master
result_MemoryCode=stmt2.executeQuery("Select * from
dick.Memory_Code_Master where memory_code = " + "'" + result.getString
("memory_code") + "'");
result_MemoryCode.next();
//Brand Name Master
result_Brand_Name=stmt3.executeQuery("Select * from
dick.Brand_Name_Master where brand_code = " + "'" + result.getString
("brand_code") + "'");
result_Brand_Name.next();
//Supplier Master
result_Supplier=stmt4.executeQuery("Select * from
dick.Supplier_Master where supplier_code = " + "'" + result.getString
("Supplier_Code") + "'");
result_Supplier.next();
}
} catch (Exception e) {
System.out.println( e.toString() );
}
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
<style type="text/css">
<!--
-->
</style>
</head>
<body bgcolor="#FFFFFF">
<table width="75%" border="0" align="center">
<tr>
<td width="24%"><b>Category</b></td>
<td width="76%"><%=result_Category.getString("Description") %></td>
</tr>
<tr>
<td width="24%"><b>Memory Size</b></td>
<td width="76%"><%=result_MemoryCode.getString("Description") %></td>
</tr>
<tr>
<td width="24%"><b>Brand Name</b></td>
<td width="76%"><%=result_Brand_Name.getString("Description") %></td>
</tr>
<tr>
<td width="24%"><b>Supplier Name</b></td>
<td width="76%"><%=result_Supplier.getString("Description") %></td>
</tr>
<tr>
<td width="24%"><b>IC Base</b></td>
<td width="76%"><%=result.getString("IC_BASE") %></td>
</tr>
<tr>
<td width="24%"><b>ECC</b></td>
<td width="76%"><%=result.getString("ECC") %></td>
</tr>
<tr>
<td width="24%"><b>Speed</b></td>
<td width="76%"><%=result.getString("SPEED") %></td>
</tr>
<tr>
<td width="24%"><b>CAS Latency</b></td>
<td width="76%"><%=result.getString("CAS_LATENCY") %></td>
</tr>
<tr>
<td width="24%"><b>Config</b></td>
<td width="76%"><%=result.getString("CONFIG") %></td>
</tr>
<tr>
<td width="24%"><b>PCB Layer</b></td>
<td width="76%"><%=result.getString("PCB_LAYER") %></td>
</tr>
<tr>
<td width="24%"><b>Packing</b></td>
<td width="76%"><%=result.getString("PACKING") %></td>
</tr>
</table>
</body>
</html>
But I got the following error if the record is not found:
Error: 500
Location: /web/testing01/search.jsp
Internal Servlet Error:
javax.servlet.ServletException: Exhausted Resultset
at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:459)
at testing_00030_00031.
_0002ftesting_00030_00031_0002fsearch_0002ejspsearch_jsp_135._jspService
(_0002ftesting_00030_00031_0002fsearch_0002ejspsearch_jsp_135.java:225)
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:812)
at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
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: Exhausted Resultset
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:273)
at
oracle.jdbc.driver.OracleStatement.prepare_for_new_get(OracleStatement.java:2400)
at
oracle.jdbc.driver.OracleStatement.getStringValue(OracleStatement.java:2535)
at
oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:305)
at
oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1374)
at testing_00030_00031.
_0002ftesting_00030_00031_0002fsearch_0002ejspsearch_jsp_135._jspService
(_0002ftesting_00030_00031_0002fsearch_0002ejspsearch_jsp_135.java:180)
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:812)
at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection(Ajp12ConnectionHandler.java:166)
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)
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
