Prev: pass an XML Document from .net client to a JAVA Web Service
Next: what is base() in inheritance
From: Arne Vajhøj on 12 Jun 2010 21:29
On 11-06-2010 11:37, Mel Weaver wrote:
> "bixbarton" <bixbarton(a)gmail.com> wrote in message
> news:a9bc5498-e3f8-4a04-80ca-9a55e5459122(a)g19g2000yqc.googlegroups.com...
>> Hi, I've got a small program, using a DataSet and OracleDataAdapter.
>>
>> Fills a table ok.
>>
>> Loop through the rows ok.
>>
>> Change a couple of values.
>>
>> Then perform an Update on the OracleDataAdapter and it gives me the
>> dreaded...
>>
>> "Concurrency violation: the UpdateCommand affected 0 of the expected 1
>> records."
> I don't know much about Oracle but with SQL server each table must have
> a primary unique key, if not you will get the concurrency error.

Note that this must be a DataAdapter/DataSet requirement, both
Oracle and SQLServer actually allows tables with no PK.

My guess is that it is extremely rare in Oracle database - if you
can afford the Oracle license, then you can also afford to hire
a DBA that has a clue.

Arne

 | 
Pages: 1
Prev: pass an XML Document from .net client to a JAVA Web Service
Next: what is base() in inheritance