Hello,
If you run a simple INSERT statement on AIX via Devart.Data.Oracle.OracleCommand.ExecuteNonQuery, a parameter of type OracleDate with a value passed as DateTime is not transferred to the server properly. The Year is not BinaryFormatted property. In particular, while the lower 8 bits of the year is passed correctly, the upper 8 bits of the yeare seems to be scrambled by the value of the lower 8 bits. This looks very much like a LittleEndian/BigEndian problem. AIX is a BigEngian-Machine while x86/AMD64 machines are LittleEndian.
You can download a test application here. If this one is executed on an AIX machine (and most likely all other LittleEndian machines) you should be able to reproduce the error.
Unfortunately, this is a quite urgent problem. Do you have a quick , or any, solution for this?
EDIT: We not only have this problem with the DATE datatype but a similar one with the NUMBER datatype as well. I think the problem has the same case.
Greetings - Richie
AIX: Year of Oracle DATE datatype is not properly sent to Se
-
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
-
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
Hi,
I experienced similar problems with another component running on a big endian machine and dealing with byte wise encoding of native data formats (FlexCel).
They used the System.BitConverter class, which encodes and decodes multi byte data types with the endianess of the particular platform. This is not desired behavior, if you deal with platform independent native data types. Maybe this is the problem here as well?
Greetings - Richie
I experienced similar problems with another component running on a big endian machine and dealing with byte wise encoding of native data formats (FlexCel).
They used the System.BitConverter class, which encodes and decodes multi byte data types with the endianess of the particular platform. This is not desired behavior, if you deal with platform independent native data types. Maybe this is the problem here as well?
Greetings - Richie
-
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
-
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
The new 5.55.97 Beta build of dotConnect for Oracle is available now. It can be downloaded from
http://www.devart.com/dotconnect/oracle/download.html
(trial version) or from Registered Users' Area (for users with active subscription only). For more information, please refer to
http://www.devart.com/forums/viewtopic.php?t=17143
Please inform us whether the problem is completely resolved by this fix.
http://www.devart.com/dotconnect/oracle/download.html
(trial version) or from Registered Users' Area (for users with active subscription only). For more information, please refer to
http://www.devart.com/forums/viewtopic.php?t=17143
Please inform us whether the problem is completely resolved by this fix.