Disclaimer: I have not worked with Oracle in a while, so I am just forwarding some posts (unverified).
The analysis in this post seems to suggest that the problem is associated with the Oracle 11g JDBC driver. http://stackoverflow.com/questions/22305466/oracle-date-compare-broken-because-of-dst The recommendations appears to be to upgrade to 12c (which appears to be “New!!” :) ) http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html As I said, I have not personally verified this. HTH, Joe > On Jul 31, 2015, at 1:25 PM, Andrus Adamchik <and...@objectstyle.org> wrote: > >> We found a possibility in setting a certain timezone on the java connection. > > Could you show an example of this? > > >> On Jul 31, 2015, at 5:18 PM, Markus Reich <markus.re...@markusreich.at> >> wrote: >> >> Hi, >> >> we've some problems with oracle and timzone in combination with daylight >> savings :-( >> When I search the web to this topic, I can see that we are not the only one >> having problems concerning oracle and daylight saving ;-) >> But it seems that there's no proper solution to fix it :-( >> >> We found a possibility in setting a certain timezone on the java connection. >> My question what would be the best solution in cayenne to set the timezone >> on the based java connection object? >> >> br >> Meex >