.Net Data Provider for Oracle


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: .Net Data Provider for Oracle

  1. #1
    Bobbie Guest

    .Net Data Provider for Oracle


    We have downloaded the new .Net Data Provider for Oracle. It accesses the
    Oracle (Unix) database just fine - updates and retrieves data. The problem
    we are having is with the connections being closed. We understand that this
    provider does not support connection pooling. But it seems that the Connection.close
    command does not close the connections. The result is that in a short time
    we exceede our maximum allowed connections to the database.

    In the Windows app, the connections seem to close more often. We are guessing
    that when this app closes that Garbage collection runs. However, in our
    Web app, the connections never close.

    Do we need to use the Dispose method? Is there someting else we are missing.

    Any ideas would be appreciated!

  2. #2
    PWilmarth Guest

    Re: .Net Data Provider for Oracle


    If you can't use the close method, then my immediate thought is to use dispose;
    you just can't guarantee when it the garbage collector will dispose of
    it.

  3. #3
    Bobbie Guest

    Re: .Net Data Provider for Oracle


    "PWilmarth" <pwilmarth80231@msn.com> wrote:
    >
    >If you can't use the close method, then my immediate thought is to use dispose;
    > you just can't guarantee when it the garbage collector will dispose of


    >it.


    We added the dispose to every procedure that had an 'open' connection. The
    connections still just sat there open, even after the web page had been closed
    for 10 to 15 minutes.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center