The problem is that your Connection and CallableStatement go out of scope
when your Esegui method returns, so the ResultSet is no longer valid at the
point you are trying to use it in your JSP.
--
Martin Cooper
Tumbleweed Communications
----- Original Message -----
From: "Robuschi (Delfi)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 21, 2000 5:33 AM
Subject: Re: Database access in JSP...
> Hello everybody!!!!!!!
>
> I'm trying to return a resultset from a Javabean but it doesn't work. So I
> send you the code, hoping that someone can solve my problem.
>
> XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
> JAVABEAN:
> public class provabean {
>
> public ResultSet Esegui(int numero) {
> try
> {
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> Connection con = DriverManager.getConnection("jdbc:odbc:wds","sa","");
> CallableStatement cs = con.prepareCall( "{call pippo(?)}");
> cs.clearParameters();
> cs.setInt(1,numero);
> System.out.println("Ciao6");
> ResultSet rs = cs.executeQuery();
> return rs;
> } catch (Exception E) {
> System.out.println("Errore : "+E.getMessage());
> return null;
> }
>
> }
> XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXx
> JSP PAGE:
> <jsp:useBean id="prova" class="provabean" />
> <HTML>
> <HEAD>
> <TITLE>ELENCO OGGETTI PER PADRE
> <%
> import java.sql.*;
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> %>
> </TITLE>
> </HEAD>
>
> <BODY BGCOLOR="#FFFFFF">
> <%
> ResultSet pippo = prova.Esegui(Integer.parseInt(IdFather));
> while (pippo.next())
> {
> out.println(pippo.getString("object")+"<BR>");
> }
> pippo.close();
> %>
> </BODY>
> </HTML>
>
> Can anyone give me some help?????
>
> Thanks to everybody!!!!!!!!!!!
>
> Roberto
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> 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".
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
