Dave, I tried the link you supplied, and it didn't resolve, do you have a
different link by chance?



                                                                                       
           
                    "Dave Smith"                                                       
           
                    <sat-guru@hom        To:     [EMAIL PROTECTED]        
           
                    e.com>               cc:     (bcc: Greyson Smith/CCMG/CVG)         
           
                                         Subject:     Re: How to use JDBC in JSP & 
servlet        
                    04-11-00                                                           
           
                    01:41 PM                                                           
           
                    Please                                                             
           
                    respond to                                                         
           
                    tomcat-user                                                        
           
                                                                                       
           
                                                                                       
           





Viet,

When you are learning the API, obviously
your first projects will use sql Connections
inside servlets and JSP. This is not very
maintainble code, though. A better plan is to
encapsulate all the JDBC code in a layer
between the JSP and the DB:

    DB --> Persistence layer --> JSP --> User.

There is no cut and dried way to do this,
however. Yes, Connection Pooling is
essential. Again, there is no one way to do it.
For stand-alone systems you can use code from
Bitmechanics. In some environments (e.g.,
Websphere) connection pooling is built in.

A cool persistence layer can be found at
http://castor.exolabs.org/


Regards,

Dave





--

NOTICE:  The information contained in this electronic mail transmission is
intended by Convergys Corporation for the use of the named individual or
entity to which it is directed and may contain information that is
privileged or otherwise confidential.  If you have received this electronic
mail transmission in error, please delete it from your system without
copying or forwarding it, and notify the sender of the error by reply email
or by telephone (collect), so that the sender's address records can be
corrected.



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]

Reply via email to