- 3,715,830 Users
- 2,242,890 Discussions
- 7,845,632 Comments
Forum Stats
Discussions
Categories
- 17 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 1.6K Databases
- 472 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 22 Multilingual Engine
- 487 MySQL Community Space
- 5 NoSQL Database
- 7.6K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 417 SQLcl
- 42 SQL Developer Data Modeler
- 184.9K SQL & PL/SQL
- 21K SQL Developer
- 1.9K Development
- 3 Developer Projects
- 32 Programming Languages
- 135.1K Development Tools
- 9 DevOps
- 3K QA/Testing
- 254 Java
- 6 Java Learning Subscription
- 10 Database Connectivity
- 66 Java Community Process
- 1 Java 25
- 9 Java APIs
- 141.1K Java Development Tools
- 6 Java EE (Java Enterprise Edition)
- 153K Java Essentials
- 135 Java 8 Questions
- 86.2K Java Programming
- 270 Java Lambda MOOC
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 10 Java SE
- 13.8K Java Security
- 3 Java User Groups
- 22 JavaScript - Nashorn
- 18 Programs
- 125 LiveLabs
- 30 Workshops
- 9 Software
- 3 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 3 Deutsche Oracle Community
- 11 Español
- 1.9K Japanese
- 2 Portuguese
Exception when using OraCommandBuilder after fetching Command
I've written a simple program the fetches data into a DataSet, updates the data and uses a CommandBuilder to write the changes back to the database. Works fine. If, before calling DataAdapter.Update, I use the GetUpdateCommand to get fetch the UpdateCommand (I did this for diagnostic purposes), the DataAdapter.Update now fails with a "ConcurrencyViolation: the UpdateCommand affected 0 rows". Why? I might want to change the UpdateCommand but retain the builder's Insert and Delete commands, but it doesn't look like I can fetch the UpdateCommand.
DataSet ds = new DataSet();
OraDataAdapter da = new OraDataAdapter("select * from emp", "myconnectstring");
da.Fill(ds, "emp");
// update ds here omitted
OraCommandBuilder bld = new OraCommandBuilder(da);
// if I uncomment the next line Update fails
// without it, Update works
//da.UpdateCommand = bld.GetUpdateComamnd();
da.Update(ds, "emp");
Bob Beauchemin
[email protected]
DataSet ds = new DataSet();
OraDataAdapter da = new OraDataAdapter("select * from emp", "myconnectstring");
da.Fill(ds, "emp");
// update ds here omitted
OraCommandBuilder bld = new OraCommandBuilder(da);
// if I uncomment the next line Update fails
// without it, Update works
//da.UpdateCommand = bld.GetUpdateComamnd();
da.Update(ds, "emp");
Bob Beauchemin
[email protected]
Comments
-
Bob,
This is actually the same issue covered in:
"Concurrency violation: the UpdateCommand affected 0 records".
Please read the details provided in the above named discussion topic.
thanks,
nari.
This discussion has been closed.