The problem has been sorted out.
It was because I was closing the database connection before returning the
resultset.
-----Original Message-----
From: dbg consulting [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 2:01 PM
To: [EMAIL PROTECTED]
Subject: Re: SocketException
try executing the same logic in the bean from the command line. This would
require a main method. Step through it in a debugger if you have to. There
is not enough information in your jsp code snippet to tell what the problem
is. My first guess is that it is happening in your bean.
>From: "Singh, Jasbinder" <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
> reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: SocketException
>Date: Wed, 17 Jan 2001 16:06:08 -0800
>
>Hi All,
>I have a jsp that retrieves values from a table through a bean.
>I get the following error.
>
>-79716 java.sql.SQLException: null java.net.SocketException: Socket closed
>I am using Informix.
>
>Here is my code.
>
><jsp:useBean id="rangeBean" scope="page" class="range.RangeBean" />
>
><body>
>
><form>
>
><%
>
> java.sql.ResultSet rs = null;
>
> rs=rangeBean.getMembers();
> try {
> while(rs.next())
> {
> out.println(rs.getString(1)+"<br>");
> }
> }
> catch(java.sql.SQLException e) {
> out.println(e.getErrorCode()+" "+e.toString());
> }
> catch(Exception e) {..}
> %>
>
>Can somebody help me out.
>
>Thanks
>JS
>
>===========================================================================
>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
>
>===========================================================================
>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
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
===========================================================================
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
===========================================================================
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
