No More Handles

kishore kumar

No More Handles
Hi List,

Off late we get these errors in the online application.
"[IBM][CLI Driver] CLI0129E No more handles. SQLSTATE=HY014 " .
It started happening when we upgraded to DB2 V7 on S/390. Our online
application is written in java and use webshpere 5.0 and DB2 connect V7 on
AIX 5.0. We tried many things but none of it helped. Any suggestions or
solutions are greatly appreciate.

Thank you,
Kishore

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Abhijit Sinha

Re: No More Handles
(in response to kishore kumar)
Make sure you close your Statement, PreparedStatement, CallableStatement &
ResultSet objects when done with them. Keeping too many of these open and
then trying to open fresh ones can give this error.

Abhijit

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Kishore
Sent: Tuesday, December 30, 2003 5:22 PM
To: [login to unmask email]
Subject: No More Handles


Hi List,

Off late we get these errors in the online application.
"[IBM][CLI Driver] CLI0129E No more handles. SQLSTATE=HY014 " .
It started happening when we upgraded to DB2 V7 on S/390. Our online
application is written in java and use webshpere 5.0 and DB2 connect V7 on
AIX 5.0. We tried many things but none of it helped. Any suggestions or
solutions are greatly appreciate.

Thank you,
Kishore

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm