This content has been marked as final. Show 10 replies
Have you changed JDK?
Look in Help | About | Properties. Is there a difference in "user.timezone?"
Just 5min ago I tried with the newest JDK 1.6.0_24 and still have the same problem.
In both versions of SQL-Developer the "Help | About | Properties" shows the same user.timezone "Europe/Berlin".
Anything else I could check?
I found something but need confirmation:
SQL-Developer says my timezone is "Europe/Berlin".
If I run this:
I get no hits with "Berlin" in it but quite a few others.
SELECT * FROM V$TIMEZONE_NAMES WHERE tzname LIKE 'Europe/%'
One of them is "Europe/Istanbul".
If I now add "AddVMOption -Duser.timezone=Europe/Istanbul" to my sqldeveloper.conf I can finally connect to my Database!
So does version 3.0.03.97 of SQL-Developer somehow check this view for available timezones? Did the previous version not check this? Whats the solution for me then? (using the Istanbul timezone here doesn't seem right to me)
I have the same problem connecting to 10g db with sqldev 3.0.04.34.
Connect fine to 11g db.
fixed on mine by adding my timezone to sqldeveloper.conf
I still have the problem with 3.0.04.34 but could solve it with this:
Since I am not really sure what the consequences of this are I think it's not right.
I live in germany, and just two days ago summer time began. So half of a year this setting is not right for me and I would have to change it every half year!
With CET you should be OK, CET is shifted +/- 1 hour in regard to summer/winter time1 person found this helpful
check out http://wwp.centraleuropeantime.eu/
Thanks for the info! Nice to know that this should work right for me then.
I still don't understand why I have to create this setting at all though.
I had a similar problem, and it was solved by adding that line:-
The alternative on Linux would be set TZ variable to CET. In my case it is CEST (summer time) and it does not work:
I suspect it shall be a list of timezones in sqldeveloper to match against to, so it may be an easy fix. Would anyone report a bug?