Hi Roberto,
You can't return a ResultSet object from a bean to a JSP page 'cuz it is
not serializable. One thing you can do is, Just copy the contents into a Vector
(You can use Vector of Vectors if u have more than one rows in ur resultset) and
return that vector to your JSP page.
Hope I understood your problem
Sanjeev.
"Robuschi (Delfi)" wrote:
> 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
