Logo 
Search:

Asp.net Forum

Ask Question   UnAnswered
Home » Forum » Asp.net       RSS Feeds

Anyone use Oracle Data Providers for .Net?

  Asked By: Dale    Date: Oct 13    Category: Asp.net    Views: 705
  

I'm not quite sure how to commit/end a transaction with the Oracle
Data Providers for .Net. I've been having problems with database
performance, and even had to get the DBA to restart the database.
Somehow it keeps running low on memory. The machine is plenty
powerful (Sun Solaris).

I'm closing the connection in the finalize method of my object.
Should I be doing something else?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Sheryl Morgan     Answered On: Oct 13

Are you closing  readers?

http://www.learnasp.com/freebook/learn/dbopen.aspx

Notice the Rdr.Close and Conn.Close

It also is imperative on a busy site or code that might error to do that in
a FINALLY block....

 
Answer #2    Answered By: Brian Ross     Answered On: Oct 13

I've implemented a dispose and finalize method  and told the other
developers to be sure to call these methods when they're done with
the objects. Hopefully this will help.

I'll test for a few days and if I still have problems  I'll let you
know.

 
Didn't find what you were looking for? Find more on Anyone use Oracle Data Providers for .Net? Or get search suggestion and latest updates.




Tagged: