Direct=true with TIMESTAMP WITH TIMEZONE timezone offset bug

Direct=true with TIMESTAMP WITH TIMEZONE timezone offset bug

Postby mas » Wed 05 Jan 2011 12:38

I have a table, MyTable, with a column, Timestamp, of type TIMESTAMP WITH TIMEZONE. The entity model generated from this assigns the DateTime type to the Timestamp property of MyTable. Unfortunately, the DateTime has no timezone offset information contained in it (as opposed to DateTimeOffset).

I have noticed different behaviour between Direct=True vs Direct=False.

I insert a MyTable entity with Timestamp set as follows, my timezone is GMT+1:
Code: Select all
myTable.Timestamp = DateTime.Now;


I get the following value for Timestamp in the database:
    Direct=true (Direct mode): 05.01.11 13:19:40,732423 +00:00
    Direct=false (Oracle client mode): 05.01.11 13:19:49,663316 +01:00


It seems that in Direct mode, the DateTime is assumed to be UTC time. The Oracle Client seems to take the system's offset and assume that the DateTime is local time.

In Direct mode, shouldn't the DateTime assumed to be local time, like how the Oracle client handles it, or is this expected behaviour?

This causes problems for us because the data in the TIMESTAMP WITH TIMEZONE columns are different depending on whether Direct mode is true or false. The data should be the same no matter what mode I am using.

I am using Devart dotConnect for Oracle Professional 6.0.58.0.
mas
 
Posts: 25
Joined: Mon 15 Nov 2010 12:09

Postby mas » Mon 10 Jan 2011 09:05

Is there anyone looking into this? Does anyone understand the problem I am having? Is this a bug or expected behaviour? If needed, I can come up with a sample project to demo this.

In our project, we would like to deploy with Direct=true, since it saves us the hassle of installing the Oracle client. However, if this is expected behaviour, then we can change our code to match the behaviour we need.

If this is a bug, then I guess we will have to wait for a fix. For now, I think we are stuck using the Oracle client.
mas
 
Posts: 25
Joined: Mon 15 Nov 2010 12:09

Postby Shalex » Mon 10 Jan 2011 15:00

We have reproduced this behaviour and are investigating the issue now. I will notify you about the results as soon as possible. Sorry for the delay.
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

Postby Shalex » Thu 13 Jan 2011 11:22

We have fixed the problem with timezone in the Direct mode. I will post here when the corresponding build is available for download.
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

Postby Shalex » Thu 27 Jan 2011 16:29

New version of dotConnect for Oracle 6.10 is released!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only): http://secure.devart.com/ .
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=20115 .
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle