ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Connection leak problem

67070May 23 2003 — edited Jun 6 2006

Oracle client 9.2.0.2
Oracle ODP.NET 9.2.0.2.102
.NET framework SP2

I've got a connection leak problem with my Web site. Even if I close and dispose my connections, they "get stuck" in the connection pool (stays INACTIVE in then connection pool). The only way I find to release them is to kill the aspnet_wp.exe and dllhosts.exe process. I try to use de "Connection Lifetime" attribute of the connectionstring but it doesn't work. It brings up another bug, I if kill the oracle session related to those connections, they doesn't disappear from the connection pool so when I try to execute a query on my database, I get a "End of file on communication channel" error. It seems that the connections aren't "refreshed" and properly released by the Oracle ODP.NET driver and the connection pool. We were using Oracle OLEDB provider before and this problem does not exist with this driver. I've read the article Q330126 from Microsoft related with the same bug with their native driver for Oracle but Oracle does not seem to have the same fix. Does anybody have a idea ???

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 4 2006

Added on May 23 2003

#odp-net

36 comments

20,797 views