Ok...
I'm been clouddy... heheheh
I'm working with Tomcat 4.01b and I have a database in Oracle.
I'd installed tomcat and I know I need use JDBC to do the connection with my
database, so I put the file classes12.zip(Oracle 8i jdbc file) in the
classpath.
But the code I was send to you dont work. And the error's page open...
Thanks
-----------------------------------------
Walter Priesnitz Filho
Mestrando em Ciencia da Computacao
[EMAIL PROTECTED] | [EMAIL PROTECTED]
http://www.inf.ufsc.br/~walterp
-----------------------------------------
----- Original Message -----
From: "Hung Yee" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 5:37 PM
Subject: Re: JSP + ResultSets
> You should send us the code that you're having problems with so that we'll
> know the details of your problem.
> Please be as specific as possible so that we don't have to 'guess' ;-(
>
> -----Original Message-----
> From: Walter Priesnitz Filho [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 06, 2001 11:37 AM
> To: [EMAIL PROTECTED]
> Subject: Re: JSP + ResultSets
>
>
> I found a code in Java Developer's Journal and I'm trying but I'm not vad
> success.
> Could you help-me?
>
> Thanks...
> -----------------------------------------
> Walter Priesnitz Filho
> Mestrando em Ciencia da Computacao
> [EMAIL PROTECTED] | [EMAIL PROTECTED]
> http://www.inf.ufsc.br/~walterp
> -----------------------------------------
> ----- Original Message -----
> From: "Joseph Ottinger" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, February 06, 2001 4:01 PM
> Subject: Re: JSP + ResultSets
>
>
> > >Hi all,
> > >I need help with an apllication.
> > >I need make a query in an Oracle Table and put the result in a html
> table.
> > >How can I pass the resultset from Oracle to JSP?
> > >Does anybody help-me???
> >
> > You don't "pass the resultset from Oracle to JSP."
> >
> > I don't know what kind of architecture you're using, but here's a
simple,
> > incomplete, and quite flawed example:
> >
> > <!-- ... assume full setup has been done, to the point where the
> Connection
> > is in a variable called "conn" -->
> > <table>
> > <%
> > PreparedStatement ps=conn.createPreparedStatement("select * from
> my_table");
> > ResultSet rs=ps.executeQuery();
> > while(rs.next())
> > {
> > out.println("<tr><td>"+rs.getString(1)+"</tr></td>");
> > }
> > rs.close();
> > %>
> > </table>
> >
> > Voila! Table from a resultset! Lacks all exception handling and error
> > trapping, uses massive scriptlets, as maintainable as... um... well,
it's
> > not really maintainable.
> >
> > A better route would be to use EJBs or a MVC approach (where a front end
> > servlet is responsible for constructing the resultset).
> > _________________________________________________________________
> > 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
>
>
===========================================================================
> 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
