Jaspersoft BI Tools

iReport,Jaspersoft Design Studio,Jaspersoft Server, Schema Workbench,Analysis,Dashboards, Self Service BI, Domains,Topics,Ad-Hoc Reports, Jaspersoft ETL, Embedding BI,HTML-5 charts, Fusion Charts,JFree Charts,Drill down reports , Drill down Dashboards,Visualize.js, Performance Tuning, D3 Charts, Jaspersoft Customization

Wednesday, March 05, 2014

Timezone issue while connecting to Oracle database from SQL developer client Tool

Hi Guys..

You need to modify sqldeveloper.conf
Steps are given below
1)  Go to the installation directory of Oracle SQL Developer.
2)  Open the file located at: sqldeveloper/bin/sqldeveloper.conf.
3)  At the end of file, add the following line:
    AddVMOption -Duser.timezone=GMT-4

4) Now, restart the SQL developer tool from command prompt.
 Command to start :
sqldeveloper/sqldeveloper/bin$sh sqldeveloper.sh

5) Connect to data base and test the connections now, you will not get time zone error while connecting. 

I believe in "Learning never exhausts the mind"