Hi Berry,
I can't comment on that as I use JRun in which it is possible to
have chosen
servlets Pre loaded when the JRun servlet engine is started.
But yes, the general point was that a persistent connection pool would
be a better
solution than connecting to a database through a JSP.
While I am a fan of JSP's I don't think we should try to use them for
everything
but to use them for what they are good at , i.e. separating a web
application's
display from it's internal logic. Servlets on the other hand are to be
used for
what they are good at, i.e. as servers, and servers are for serving
information at
the request of a user, not for presentation logic.
The J2EE Programming model was very useful to me as a way of separating
out the
different modules needed in a web ap.
Karl
berry wrote:
> I think it is good to partition data access out of a JSP page
> from a OO point of view, but how is it any more efficient
> getting a connection in a servlet than from a page?
>
> I guess one solution would be to make the servlet persistent
> (one instantiation for all requests) and have it maintain
> a pool of connections. Can you make a servlet persistent
> in pure web servers like Apache or Netscape? Most
> App servers I have worked with have that feature.
>
> Berry Crawford
>
> ----- Original Message -----
> From: Karl Roberts <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, November 15, 1999 5:38 AM
> Subject: Re: JDBC from JSP
>
> > Hi Sudha,
> > In my humble opinion Connecting to a Database from a JSP is not such a
> good
> > idea due to the time taken to connect. However there are many other ways
> like
> > passing the request ,etc. to a servlet or to an Enterprise Java Bean to
> handle the
> > Database connectivity.
> >
> > The J2EE has a programming model that merges these methods and you can
> find it at
> >
> http://developer.javasoft.com/servlet/SessionServlet?url=http://developer.ja
> vasoft.com/developer/earlyAccess/j2sdkee/download-docs.html
> >
> > or go to
> > http://developer.java.sun.com/developer/products/j2ee/
> >
> > hope this helps
> >
> > Karl
> >
> > Sudha Gopalakrishnan wrote:
> >
> > > Hi,
> > >
> > > Can someone point me to an example where you do
> > > database connecctivity from a JSP page. ( Like you use
> > > ADOs in ASPs, what is the equivalent in JSPs?)
> > >
> > > Thanks,
> > > sudha
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Bid and sell for free at http://auctions.yahoo.com
> > >
> > >
> ===========================================================================
> > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> > > FAQs on JSP can be found at:
> > > http://java.sun.com/products/jsp/faq.html
> > > http://www.esperanto.org.nz/jsp/jspfaq.html
> >
> >
> ===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> > FAQs on JSP can be found at:
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
>
> ===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
> FAQs on JSP can be found at:
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
