Re: AS/400 JDBC Connection

[Bruce Jin <brucej@xxxxxxxxxxxxxxxxxxxx>]

If you only have a few servlets and the traffic is not that heavy you 
can open/close connection in your servlet. However you should open 
connection in init method and close it in destroy method so that they 
are done only once in the life time of the servlet. Make sure the method 
signatures are right so that they really override the ones in super class.

If you have many servlets and have heavy traffic it is a good idea to 
setup a connection pool.


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.
>