David, This sounds like the DB2 equivalent of Oracle's maximum cursors error. Every time a Statement is created it opens a cursor in the database. If you don't explicitly close the Statement then that cursor remains open for the life of your connection. Thus, eventually the maximum number of allowed cursors for one DB session is exceeded (usually 50). Cheers, Lindsay. > -----Original Message----- > From: David Snyder [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, July 07, 1999 3:21 AM > To: [EMAIL PROTECTED] > Subject: No more handles.. > > Servlet Description: > > I have a servlet that receives parameters from a html page. The parameter > determines the class that is to be called from the service method. Each > class > performs certain JDBC functions and outputs the results to the browser. A > single database connection is created in the init method of the servlet. > That > connection is then passed to the classes when they are called, so they can > perform their JDBC functions. > > Problem Description: > > The above servlet and its classes work fine for a brief period of time. > After > several requests are handled, the servlet starts to receive a > DB2.Exception, no > more handles. > > Has anyone else come across anything like this before? I am beginning to > think > that passing one single connection to the classes is the culprit?? Any > ideas.... > > __________________________________________________________________________ > _ > To unsubscribe, send email to [EMAIL PROTECTED] and include in the > body > of the message "signoff SERVLET-INTEREST". > > Archives: http://archives.java.sun.com/archives/servlet-interest.html > Resources: http://java.sun.com/products/servlet/external-resources.html > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
