SQL Developer

I'm guessing you have an old copy of SQL Developer, so you need to go into the sqldeveloper.conf file (it's in the sqldevleoper/bin folder) and find

SetJavaHome

and make sure it is set to the path for your JDK.

SQL Developer requires Java.

You'll want Java 6 or 7 depending on how old sqldev is - I'm assuming you're running the one that shipped with Oracle Database 11gR2

You can also skip all this and just go to our OTN page and download 4.1.1 with the embedded JDK. Unzip, run the exe in the main folder, good to go.

Hi Jeff

Thanks for your reply

The SQL Developer I have installed is "sqldeveloper-4.1.1.19.59-x64"

Downloaded just yesterday

The Java ... I have installed is "jdk-8u60-windows-x64"

Also downloaded just yesterday

So I guess these must be the current versions

I have found the file you mention (sqldeveloper.conf file)

How can I edit or open this? Opening its properties doesn't seems to get me anywhere.

Hein

did you download the one that said:
Windows 64-bit with JDK 8 included

If so, it shouldn't matter

If you're still having problems, with v4.1.1 you need to go to your Application Data directory for your windows OS user, find the 4.1.1 directory under that and edit the product.conf directory

I talk about that here

The file you mentioned is indeed the file I have downloaded and installed

The dialog box you mention in your article is what I saw yesterday

I must have chosen the wrong file to point to

I have opend the conf file (using notebook) and found this line : "SetJavaHome C:\Program Files\Java\jdk1.8.0_60"

In programm files there is a directory like that with a copyright, license and release file,

also a readme.html, 2 text docs and 2 zip files

Also I see subdirs bin, db, include, jre and lib

However: all this is not in the C:\users directory I see in the picture in your article, it is in the directory you mentioned earlier

For my feeling I am running incircles

Is there a way out?

Hein

delete that conf file

run sqldev again

if it prompts you for the java home again (weird!), point it to the java jdk directory in your sqldeveloper 4.1.1 install

Sorry Jeff

I give up

It's not your help, this is obviously not my expertise.

I am completely lost what to do.

It is getting late in the Netherlands. Tomorrow I will reread this thread and start all over again

I will get back to you with my results / experience

For now: thank you

Hein

Hi all,

I have the exact same issue, before the update to the  java 8u60 my SQL Developer was working on java 8u51

After the update SQL Developer asked me again to specify the Java JDK home.

I will describe what I have tried so far:

1-     Uninstall Java

2-     Download Java again, file jdk-8u51-windows-i586.exe

3-     The sql developer that I use is sqldeveloper-4.1.1.19.59-no-jre.zip

4-      Tried to remove the product.conf or change the JavaHome to my jdk path which is C:\Java

The only thing that works is to uninstall  java 8u60 and install again java 8u51, with that I can get SQL Developer to work again.

This seems to be an issue with the last version of java.

Does anyone have a solution for this? I still can't find a way to have sql developer working with java 8u60.

i'm using 1.8.0_60 on WIN7x64 with SQLDev 4.1.1.19

my java home is

c:\program files\java\jdk1.8.0_60

>>After the update SQL Developer asked me again to specify the Java JDK home.

Then what?

Do you enter the java home?

If you do, then what happens?

Hi Jeff,

Thanks for your fast reply.

I am using Win7 x32 with SQLDev 4.1.1.19 and java 8u60 x32.

My java home is C:\Java.

Anyway when SQL developer pop up asks for the Java JDK home, I choose C:\Java (like it was on java 8u51) and It says that no jdk was found on the path provided.

Regards,

NF

>>C:\Java

That's wrong.

See what I entered for mine. yours should be similar.

Hello Jeff,

Thanks for your reply.

I have installed Java my jdk C:\Java not on the default c:\program files\java\jdk1.8.0_60, because I don't like to have spaces on my Java Home path, It can be tricky for other things, I have doing that since alway

Like I mentioned before it worked when I installed Java 8u51, why is not working anymore after the update, that needs to be something related to the java version, anyway I have uninstalled and installed again java 8u51 and his working properly.

Just as a test I will try to install java 8u60 on the default location and delete the product.conf to be asked again.

I will let you know.

Cheers,

NF

Hi Jeff,

What a stupid and annoying bug.

I installed like mentioned on my previous post java 8u60 without changing the installation path and since I did not have uninstalled java 8u50 I have deleted the produc.conf to force SQL Developer to ask me for the new JDK home path.

Now SQL Developer worked correctly and was able to start.

It seems that changing the installation path for java 8u60 is not recommended  which is bad, because the spaces on the path can cause me issues with other java applications I have.

Anyway is working for now but I will log this bug on oracle metalink.

Thanks for the help