Devart Forums

atomulesei

Great, thank you very much. Looking forward to it.

atomulesei

Checked with the newer versions and the problem still persists: when using the DataSet Wizard, the schema is indeed filled correctly. However, when using the OracleDataAdapter.FillSchema() method, the constraints are rendered the wrong way(separately). Any thoughts?

atomulesei

Yes, we're aware of that, and as stated at the beginning of the thread we intend to improve upon Mono code and make Oracle component run on Mono... However in this particular case it is hard to pinpoint the problem in the Mono code if we can't debug or analyze what went wrong in the query generation from Devart's point of view.

I think it is beneficial for both parties if we could analyze the problem in detail.

Running Oracle with Mono on both Ubuntu and AIX it is crucial for us, so if we won't be able to find a solution for this with Devart, we'll have to seek other components which can support us in achieving this goal.

atomulesei

Hello!

We've made some modifications related to the Mono sources related to the matters that you wrote above and managed to successfully run the test project under Ubuntu, however we got stuck with the following exception when running under AIX.

Code: Select all

Creating Connection...
Drop test table, if it already exists...
Creating table DDEML_TEST...
Creating test data...
Test case 1: Create UPDATE command with OracleCommand on a table that DOES NOT have a PK...
Creating INSERT command...
FAILED: System.Exception: NET: Unknown error 1
  at Devart.Data.Oracle.p.b (Int32 A_0) [0x00000] 
  at Devart.Data.Oracle.bm.c () [0x00000] 
  at Devart.Data.Oracle.t.a (Int32 A_0, a5 A_1) [0x00000] 
  at Devart.Data.Oracle.OracleCommand.InternalExecute (CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords) [0x00000] 
  at Devart.Common.DbCommandBase.ExecuteDbDataReader (CommandBehavior behavior) [0x00000] 
Creating PK PK_DDEML_TEST for table DDEML_TEST...
FATAL EXCEPTION: System.Exception: NET: Unknown error 1
  at Devart.Data.Oracle.p.b (Int32 A_0) [0x00000] 
  at Devart.Data.Oracle.p.a () [0x00000] 
  at xc.d.a (Byte A_0) [0x00000] 
  at xc.b.a (Byte A_0) [0x00000] 
  at xc.a.a () [0x00000] 
  at xc.e.a () [0x00000] 
  at Devart.Data.Oracle.d.a () [0x00000] 
  at Devart.Data.Oracle.t.a (Int32 A_0, a5 A_1) [0x00000] 
  at Devart.Data.Oracle.OracleCommand.InternalExecute (CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords) [0x00000] 
  at Devart.Common.DbCommandBase.ExecuteDbDataReader (CommandBehavior behavior) [0x00000]

The test code we're using is virtually the same as the one in the zip of the first post.

We're using the Devart.Oracle.Data.dll version 5.25.48.0, and the test environment is a virtual node with two POWER 3,6GHz cores running AIX 6.1. The Mono framework is a custom build from a patched version 2.4.2.3

Note: the exception occurs with the original version of the Mono build as well, without our modifications.

Thank you and any ideas are greately appreciated.

Best regards,
Adic

atomulesei

Yes, this is what I need. So I guess I'll need to upgrade.

Thanks for the quick reply.

atomulesei

Hello,

I'm currently using version 4.75.43 and have the same multiple columns constraint problem. Do you know if it has been fixed in the newer versions?
Thanks

Search found 6 matches