AIX: Year of Oracle DATE datatype is not properly sent to Se

ddeml · Post by **ddeml** » Tue 02 Feb 2010 13:28

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

StanislavK · Post by **StanislavK** » Tue 02 Feb 2010 15:59

We are investigating the situation. We will notify you about the results.

StanislavK · Post by **StanislavK** » Tue 09 Feb 2010 10:46

Please specify, which version of dotConnect for Oracle you are using. A similar issue was fixed in the 5.25.49 build.

Tobi · Post by **Tobi** » Wed 10 Feb 2010 11:23

Hi,
We tested it with 5.35.79.0, and the error still exists.
best regards,
Tobi

ddeml77 · Post by **ddeml77** » Wed 10 Feb 2010 11:41

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

StanislavK · Post by **StanislavK** » Wed 10 Feb 2010 15:56

We have fixed the problem, look forward to the nearest build.

StanislavK · Post by **StanislavK** » Thu 18 Feb 2010 13:45

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.