Introduction
You might face a sqldeveloper error while working on a Windows environment related to timezone, installing Oracle sqldeveloper 64bit edition on Windows 7 64 bit.
Background
For accessing an Oracle database you need to have the right tools. Oracle has provided developers with a solid tool (sqldeveloper 3.1), you will face no installation issues but when executing a query, you will get the timezone error.
Solution
SQL Server Developer:
Edit this config file: C:\Program Files\sqldeveloper 3\sqldeveloper\bin\sqldeveloper.conf then add this line anywhere in the file:
AddVMOption -Duser.timezone="+02:00" (My time zone)
Oracle Data Modeler
Edit this config file: C:\Program Files\datamodeler 3\datamodeler\bin\datamodeler.conf, then add this line anywhere in the file:
AddVMOption -Duser.timezone="+02:00" (My time zone)
Self-motivated, creative and results-driven technology executive who is well versed and experienced in leveraging an end-to-end, holistic vision of business objectives to drive full technology / business alignment.
Skilled in grasping business needs and sudden market demand’s shifts by diving into latest business / technology trends, selecting the best fit business model / technology to create a positive reflection on revenue. His multifaceted approach has enabled him to deliver key solutions across a wide range of disciplines including design, development, UX / UI, Business Intelligence.
Technical Specialties are in .Net, Java, Spring Boot, Maven, MS SQL, Oracle, Postgesql, Redis, Javascript, Bootstrap, Angular 2.