Very Computer

by **Christoph** » Sat, 06 Apr 2002 09:06:23

Dear DB2 community,

I'm facing the following problem (DB2 7.2/RedHat 7.2, english)
I'm using TomCat to retrieve data from DB2 using simple connection (open
connection, retrieve data and close connection). I triple check my code, and
all the close connection are there.

The problem is that DB2 does not release the connection, and there are
plenty of UWO (Unit Of Work) Waiting in the application. When a threshold is
reached (more or less 150 UOW waiting), I receive an ISE (Internal Server
Error).

I'm pretty new in TomCat/DB2, and I would definitly appreciate some
help/advise.

Thanks in advance.

Chris.

by **Fan Ruo Xi** » Sun, 07 Apr 2002 00:26:31

> Dear DB2 community,

> I'm facing the following problem (DB2 7.2/RedHat 7.2, english)
> I'm using TomCat to retrieve data from DB2 using simple connection (open
> connection, retrieve data and close connection). I triple check my code, and
> all the close connection are there.

> The problem is that DB2 does not release the connection,

1. It is hard to say db2 doesnot release the connection. If you want to know
the problem is because of db2. You can bypass the TomCat, to check if db2 do
release the connection.
2. When you issue "CLOSE" the connection from your application, have you
capture the sqlcode?
Best Regards,
Fan Ruo Xin

Quote:> and there are
> plenty of UWO (Unit Of Work) Waiting in the application. When a threshold is
> reached (more or less 150 UOW waiting), I receive an ISE (Internal Server
> Error).

> I'm pretty new in TomCat/DB2, and I would definitly appreciate some
> help/advise.

> Thanks in advance.

> Chris.