After several requests of my servlet, I get a 'No more handles' error.
CLI0129E. SQLState=HY014. My servlet calls five different classes depending on
parameters that are passed in from html pages.
The classes themselves, perform simple sql statements and data
manipulation. The data is then formatted and sent to the browser. The first
version of the servlet created a single connection in the init section and
passed that connection object to the class objects in the service method. Later
versions of experimenting used connection pooling that passed the connection
object to the class object in the service method. Even with connection pooling,
I still get a 'No more handles' error.
Maybe I should create statement objects in the init section and pass them
to the class objects instead of the connection obejct? Does anyone have any
suggestions or ideas on this subject. My last resort will be to create a new
connection every time the service method is called. I really don't want to do
this because it is expensive.
___________________________________________________________________________
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
