Concurrency Error & Retreive Default Value

Concurrency Error & Retreive Default Value

Postby franz_jp » Mon 27 Aug 2007 16:11

Hi there...

I'm using OraDirect .NET 3.55. I Have Some problem when developing.

1. When I'm using OracleDataTable and set InsertCommand, UpdateCommand and DeleteCommand together using my OracleCommandBuilder, and I 'm calling Update method a SystemNullRefference Exception is Occured... Why This Happen? But when I'm only set Update Command the update method is successfuly exceuted

2. I'm getting Concurrency Error when using Oracle Command Builder and OracleDataTable that said 0 Row Updated 1 Expected

3. How can I Retrieve the default value in OracleDataTable that have been set in Oracle Table

4. Is there any other way to AddRelation using OracleDataTable beside using dataset?

5. Why OracleCommandBuilder always generate UpdateCommand with WHERE clause is not only the Primary Key for UpdatingRecord. It's always generate all field for WHERE clause. In ODAC if I'm not wrong it is using RowID for WHERE clause.


Thanks for your Support...
Please Help because My Project Is Stuck... :?
franz_jp
 
Posts: 1
Joined: Mon 27 Aug 2007 15:22

Postby Alexey » Tue 28 Aug 2007 12:34

1. When I'm using OracleDataTable and set InsertCommand, UpdateCommand and DeleteCommand together using my OracleCommandBuilder, and I 'm calling Update method a SystemNullRefference Exception is Occured... Why This Happen? But when I'm only set Update Command the update method is successfuly exceuted
2. I'm getting Concurrency Error when using Oracle Command Builder and OracleDataTable that said 0 Row Updated 1 Expected
Please send me a test project to reproduce these problems. It is
desirable to use 'scott' schema objects, otherwise include definition of your own database objects. Use e-mail address provided in the Readme file. Do not use third party components.
3. How can I Retrieve the default value in OracleDataTable that have been set in Oracle Table
It is not possible in 3.55 version, unfortunately.
4. Is there any other way to AddRelation using OracleDataTable beside using dataset?
There is ParentRelation property of the OracleDataTable component. But it was added in OraDirect .NET 4.0.
5. Why OracleCommandBuilder always generate UpdateCommand with WHERE clause is not only the Primary Key for UpdatingRecord. It's always generate all field for WHERE clause. In ODAC if I'm not wrong it is using RowID for WHERE clause.
We will investigate this behaviour. I'll let you know our progress.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Alexey » Fri 31 Aug 2007 08:53

Design-time is fixed. Look forward to the next build.
In the code you will also have to set for .NET2
Code: Select all
        commandBuilder.ConflictOption = ConflictOption.OverwriteChanges;
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for Oracle