Inactive connection in Oracle8i

From: Adam Boczek <adam.boczek_at_NO_SPAM_gft-solutions.de>
Date: Fri, 13 Jul 2001 13:03:01 +0200
Message-ID: <995022251.540499@tux2.ham.acs-gmbh.de>

Hallo, that's my problem:

MTS class has a function that calls Oracle server, opens connection, performs some database operations and then closes connection. Everything seems to be ok, my MTS object disapeared, resources are free. But suddenly I can see that my connection with Oracle (in Oracle tool) persist with a status inactiv. When I call my function several times, number of inactive connection quickly reaches the maximum and my function failed. After this operation, when I shut down my MTS Package everything is ok. My function opens connection only one time and then I release resources.Whats going on, why oracle does not realese (or MTS) this connection. Pooling? (but when I call my function 100 times I have 100 inactive connections :-((((

Server MTS: Win2000, SP2, COM+
Server Oracle: Win2000, Oracle8i
Development: VB6.0 SP5

Help :-|
Adam
adam.boczek_at_gft-solutions.de Received on Fri Jul 13 2001 - 06:03:01 CDT