Thursday, October 06, 2011

Oracle SQL Developer - Change Java SDK

Oracle SQL Developer is a popular tool to connect to Oracle database and perform SQL queries (and not only). When you start SQL Developer for the first time it asks you where your Java SDK is.


You enter your JDK path and Oracle SQL Developer uses it for running in Java JVM. Now what if you want to change it? It is easy. Open [sqldeveloper_installation]\sqldeveloper\bin\sqldeveloper.conf (on my machine the path is C:\tools\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf) and modify it as following:




That is, comment out or remove the old path to Java SDK and place the new path. Now restart Oracle SQL Developer and verify that it uses the new path by going "Help->About" and selecting "Properties" tab:






















9 comments:

Anonymous said...

Excellent, thanks!!

Anonymous said...

Thanks. This was spot on and save me a ton of time.

Anonymous said...

Awesome. Thanks :)

Anonymous said...

very useful, thank you for posting.

era said...

very helpful.. thanks..

Anonymous said...

thanks!

Anonymous said...

Really helpful...

But sometimes, even after changing this wont work. In that case, need to perform the following.

Go to
C:\Users\\AppData\Roaming\sqldeveloper\1.0.0.0.0 for WIN 7

Or
C:\Documents and Settings\\AppData\Roaming\sqldeveloper\1.0.0.0.0 for WIN Xp

Open the Product.conf file

Modify the correct java path there and save the file.

Restart the SQL Developer which will solve the issue.

Anonymous said...

sometime on windows 7, you need to be administrator for this to work. Not all PCs allow this, but
1. right click the short cut and select "run as administrator"
2. enter the correct java path
3. SQL developer will save this into the conf file

you won't need to do this until you want to change the path again

Itineris said...

I still have the previous path in Properties and I don't find Product.conf

Do you have another solution for Windows 7?

Thanks