Sessions are not killed automaticvally in ORACLE using COM+

[sgotur]

Hi,

I'm using disconnected recordset object and deployed as Server object in COM+, the connections are not killed automatically on the ORACLE database, when I run the v$session table in Oracle If ound that the connections are not killed and it shows the dllhost.exe in all the connections.
I checked my connection object and all the connections are released.

Please let me know, what causing the above problem.

 

[qxu]

Hi,

Have you fixed it? We encounter a very similar problem. It will be great if you could share your findings/solutions with us. Thanks.

 

[sgotur]

I opened all my components and checked whether I closed my Recorset and connection once completed and surprisingly I found lots of places I missed. Also, I ran each transaction of my application seperately and checked the server usage and interstingly I found a query, which basically runs on a Oracle Linked table and took more time when users do a search for records with no filters.

I handled this situations carefully and now I found my COM+ services are killed once the connections are closed.

Please give a try and let me know, if you have any question and also, if you found anything other than what I said, Please update me so...

Thanks
Sreenath Gotur.

 

[qxu]

Thanks for your information.

Our situation is, it works fine on development web server. That is, all database connections could be cleaned up. However, the same set of scripts running on production web server somehow can not close all database connections.
I'm not sure if it is something wrong with the code, or something to do with different IIS version/configurations.

I will let you know once we find where the problem is.

Cheers,