OracleDataAdapter.update method hangs with 8.1.5 client

  • Thread starter Thread starter mateo
  • Start date Start date
M

mateo

Hi,

I have come across a bug that I have found no documentation or
discussion about. It's just like that one time I had a bird poop on my
head; it was not good luck either.

I'm using an OracleDataAdapter and an OracleCommandBuilder for
automatic command building to build insert, update and delete commands
from a select command. It's pretty straightfoward and I had it working
before with another database. To be more precise, the only thing that
is different is the oracle client software version (8.1.5 instead of
10g).

So the OracleDataAdapter.update() method hangs indefinitely and I then
have to kill the aspnet_wp worker process. When running on the server
the code does just fine, but the glitch happens when debugging or
executing without debugging. That means I have to push a new version to
the server every time I want to test a fix to the app.

Here's my development environnent:
- Visual Studio .Net 2003 (7.1.3088)
- .Net Framework 1.1 (1.1.4322 SP1)
- Windows XP Pro v2002 SP2
- Oracle Client 8.1.5

here's the code snippet:

using (OracleConnection objCon = Factory.Context.GetOracleConnection())
{
string strSelect = "SELECT * FROM ITM_SALESFORCE_ANALYSIS";
OracleDataAdapter objDA = new OracleDataAdapter(strSelect, objCon);
OracleCommandBuilder objCommandBuilder = new
OracleCommandBuilder(objDA);

=> intNbAffectedRows = objDA.Update(analysisTable);
}



Is this a known issue? Thanks for your help!

Matt
 
I too see this.

I have the same development environment, except we have Oracle 9.0, and
oracleclient.dll v1.1.4322.2032.

Update hangs indefinitely. I can do Updates on a test file (one
varchar, number, blob), but for my production table, it hangs ... and
hangs.

This is a real pain.
 
Back
Top