What is the way to change settings for SQL Developer to correctly recognize the current SDK version?

Question

I have Oracle 11g r2 on my machine and when I open Oracle SQL Developer it displays: java 1.6.0_02 is not supported and insists me to install a new Java version.

So I installed JDK 1.6.0_27 and set the path in environment variables and ran Oracle SQL Developer again, but I am getting the same error.

What is the way to change settings for Oracle SQL Developer to recognize 1.6.0_27 as my SDK?

Answer 1

The sqldeveloper.conf under sqldeveloper/bin in the SQLDeveloper base directory contains the entry for the used java_home.

Therefore, on Windows, if you have unzipped SQLDeveloper to C:\sqldev then sqldeveloper.conf is under C:\sqldev\sqldeveloper\bin

It must have displayed:

SetJavaHome C:\Program Files\Java\jdk1.6.0_20

You need to Quit SQLDeveloper, then remove this entry and relaunch SQLDeveloper. You will be prompted for the location of Java.

If you want to get more insights into SQL, checkout this SQL Course from Intellipaat.

Answer 2

To make SQL Developer determine the version of the current SDK, consider the following steps:

1. Open SQL developer then launch the application.

2. Make sure you have the correct version of SDK installed in device.

3. To set the jdk path-

• Under tools, select preferences.

• In database, check the path of jdk by choosing NLS. If that is wrong, change it to point at the JDK installation directory.

4. Check other related options in the Preference to see if they are valid for your version of SDK.

5. Now, reboot SQL Developer and check that your connection has successfully made it with the current version of sdk.