hi Cj
why don't you wrap the rows from your query in an object and vector like you
mentioned then use a helper class to generate the html you need. This way
you only need to pass a String back to the JSP.
Happy Thursday
DD x
----- Original Message -----
From: "Corey A. Johnson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 06, 2000 1:23 PM
Subject: Returning java.sql.ResultSet from an EJB
> Morning!
>
> Quick question... I am invoking a method in an EJB from a JSP... the
> method in the EJB performs a SQL query... Is it possible to return the
> java.sql.ResultSet object to my JSP? So i can then loop through the
> records in the JSP and build the results HTML table? I tried this and i
> keep getting an IDL error telling me that the return type
> "java.sql.ResultSet" is not allow...
>
> if i can't.. does anyone have any code examples or suggestions? Or am i
> missing something?
>
> i guess i could place the data from each field into an element of a
> String array... and then place each String array.... which would
> represent a row in the SQL ResultSet.. in a Vector... and then return
> the Vector to the JSP and use an Enumeration to loop through the String
> Arrays.... does that make sense? Or can it be done in a simpler
> fashion?
>
> Thanks in advance.
>
> Cj
> --
> Corey A. Johnson
> Creative Network Innovations, Inc.
> 1-800-264-5547 ** 1-407-259-1984
>
>
===========================================================================
> 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
