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

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

Postby 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
ddeml
 
Posts: 4
Joined: Tue 06 Mar 2007 15:54

Postby StanislavK » Tue 02 Feb 2010 15:59

We are investigating the situation. We will notify you about the results.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby 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.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby Tobi » Wed 10 Feb 2010 11:23

Hi,
We tested it with 5.35.79.0, and the error still exists.
best regards,
Tobi
Last edited by Tobi on Wed 10 Feb 2010 12:42, edited 1 time in total.
Tobi
 
Posts: 12
Joined: Wed 06 Dec 2006 17:58

Postby 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
ddeml77
 
Posts: 14
Joined: Thu 14 Jun 2007 08:56
Location: Germany

Postby StanislavK » Wed 10 Feb 2010 15:56

We have fixed the problem, look forward to the nearest build.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Postby 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.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to dotConnect for Oracle