Re: AS/400 JDBC Connection

RPower@xxxxxxxxxx wrote:

I'm trying to figure out if I should be creating and closing my connections to the JDBC each time a servlet is called or should I just open it once and leave it open? ie: public void performTask(HttpServletRequest req, HttpServletResponse resp) {

                sess = req.getSession(true);
                customer = (Customer) sess.getAttribute("customer");
                createAuditTrail = false;
                try {
                        //!---New code put in Jun 2, 2005
                        if (ds == null)
                                getDS();
                        conn = ds.getConnection();
                        dmd = conn.getMetaData();

code here.....


                conn.close();

is this efficient or am I wasting valuable resources?  Thanks,

Ron Power
Programmer
Information Services
City Of St. John's, NL
P.O. Box 908
St. John's, NL
A1C 5M2
709-576-8132
rpower@xxxxxxxxxx
http://www.stjohns.ca/
___________________________________________________________________________

Success is going from failure to failure without a loss of enthusiasm. - Sir Winston Churchill

This email communication and accompanying documents is intended only for the 
individual or entity to which it is addressed and may contain information that 
is confidential, privileged or exempt from disclosure under applicable law. Any 
use of this information by individuals or entities other than the intended 
recipient is strictly prohibited. If you have received this in error, please 
notify the sender and delete all the copies (electronic or otherwise) 
immediately.