I stated that I do not do any processing in my JSP's, there is only
enough logic in my JSP to display what I need. JSP's were developed to
separate logic from presentation. Use a SERVLET there is already too
much processing that takes place in a JSP. Go from the JSP to the
servlet back to the JSP.
----- Original Message -----
From: "Ganesh N.M" <[EMAIL PROTECTED]>
Date: Thursday, October 26, 2000 3:15 pm
Subject: TO T A Flores
> Flores,
>
> Can u just ell me how u r calling/using this code snippet in
> JSP.
>
> i.e getConnection() u used in the following?
>
> Please give me the full coding.
>
> Ganesh
>
> -----Original Message-----
> From: T A Flores
> To: [EMAIL PROTECTED]
> Sent: 10/20/00 4:11 AM
> Subject: Re: TO T A Flores
>
> No, because I am not re-connecting to the database. I do not perform
> my processing in my JSP's. Now, let me ask you this. When you close
> your connection in the servlet don't you loose the result set?
> Additionally, I do not use (regular) beans to get my connections I use
> Weblogic's Connection pooling features then perform JNDI lookup. This
> way my code is completely portable. See the following code snippet:
>
> public Connection getConnection ( ) {
> try{
> Context context = new InitialContext ( );
> javax.sql.DataSource ds = ( javax.sql.DataSource ) context.lookup
> ( "DbDataSource" );
> conn = ds.getConnection ( );
> }catch ( NamingException n){
> n.printStackTrace( );
> }catch ( SQLException s){
> s.printStackTrace( );
> }catch ( Exception ex ){
> ex.printStackTrace( );
> }
> return conn;
> }
>
> Final though do we see too much processing in JSP's.
>
>
>
> ----- Original Message -----
> From: marco <[EMAIL PROTECTED]>
> Date: Thursday, October 19, 2000 3:00 pm
> Subject: TO T A Flores
>
> > Hi all,
> > The use of all this vector and hashtable is not memory killer in JSP
> > processing???
> > Is't better to use directly the resultset in the JSP Page????
> > like:
> > ......
> > rs = stmt.excuteQuery(strSql);
> > while(rs.next()){
> > %>
> > <tr>
> > <td><%= rs.getInt("ID") %></td>
> > </tr>
> > <%
> > }
> > .......
> >
> > what of this method is better???
> > Why you use a servlet and not a JavaBean to get the ResultSet????
> > I use a JavaBean that connect to DB using connectDB() method,
> > extract the
> > ResultSet using getRs() method and disconnect DB using
> > disconnectDB()...i write this simple Bean 'cause i think is better
> > to use it... but know i'm
> > not sure... can you explain why you use this method to access DB???
> >
> > Thanx, mark
> >
> >
> >
> >
> > > I think if you were more specific about your exact problem you
> might> > get a little more assistance. At any rate, below are a
> couple> of code
> > > snipets. I use a servlet to perform the query and pass the
> > result set
> > > to a JSP. I think the following will at least give you a very
> good> > start.
> > >
> > > In the servlet . . . .
> > >
> > > rs = stmt.executeQuery( sql );
> > > while (rs.next( ) ){
> > >
> > > Vector vector = new Vector();
> > > vector.add(new Integer(rs.getInt("var1")));
> > > vector.add(new Integer(rs.getInt("var2")));
> > > vector.add(rs.getString("var3"));
> > > vector.add(rs.getString("var1"));
> > > hashtable.put(rs.getString("var1"),vector);
> > >
> > > session.setAttribute("Name the hashtable", hashtable);
> > >
> > > then in the JSP . . . .
> > > <%
> > > Enumeration enum=null;
> > > Hashtable ht = new Hashtable();
> > > Vector vec = new Vector();
> > >
> > > try{
> > > ht =(Hashtable) session.getAttribute("Hashtable
> > > Name");
> > > enum = ht.keys();
> > > int i=0;
> > > }catch(Exception e){System.out.println(e.toString());}
> > > %>
> > > <%
> > > while(enum.hasMoreElements()){
> > > vec = (Vector) ht.get(enum.nextElement());
> > > %>
> > > <table>
> > > <tr>
> > > <td><%=vec.get(0).toString()%></td>
> > > <td><%=vec.get(1).toString()%></td>
> > > <td><%=vec.get(2).toString()%></td>
> > > </tr>
> > > <%
> > > }
> > > %>
> > >
> >
> >
>
========================================================================
> ===
> > 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
>
===========================================================================
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
