Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Yesterday, I downloaded SQL Developer 3 with SDK and was able to use it just fine. After shutting down my PC last night and booting it up again this morning, every time I try to run it, I get this message:

"Enter the full pathname for java.exe"

I browse to C:\Program Files\Java\jre6\java.exe where the EXE is located and I get this message:

"Cannot find a J2SE SDK installed at path C:\Program Files\Java\jre6\java.exe"

What could be the issue here when it was working just fine yesterday? I will add that my PC did freeze last night during shutdown, so I ended up having to power it off, but I don't know if that's relevant.

I reinstalled Java and it still gives the same message. I also downloaded SQL Developer without the SDK and get the same message. I will also add that I am not actually installing SQL Developer, just running the executable from the folder. I don't think you actually install it anyway.

Anyone know what could be causing this? I am on Windows 7 32-bit.

share|improve this question
    
I appear to have fixed it my uninstalling Java and deleting the SQl Developer program folder. I then reinstalled Java and re-extracted SQL Developer and it works now. Before I put this as my answer, I'll see what everyone else has to say, if anything. –  oscilatingcretin Jan 17 '12 at 15:10

7 Answers 7

up vote 5 down vote accepted

"jre6" in the folder name implies you have JRE installed there, and not the SDK. Point it to somewhere where you have java.exe of a JDK/SDK installation, instead of JRE, and from thereon it should work.

If you had to power off during shutdown, it might've not been able to save the SDK reference, thus asking it on the next startup.

share|improve this answer
2  
After booting up my PC again today, I was greeted with the error message yet again! I searched my C drive for java.exe and found out that there was a copy deep in the folder that I extracted the ZIP file I downloaded. Specifically, it was in sqldeveloper-3.0.04.34\sqldeveloper\jdk\jre\bin. I pointed it to that and worked! –  oscilatingcretin Jan 18 '12 at 17:48

If your jdk file gets stuck on asking for the jdk file on repeat in windows 7, or you are having problems with the jdk file, try running SQLDeveloper as administrator rather than just the regular startup.

share|improve this answer
    
This was my problem. I also recommend that you only open as administrator the once, set the Java path, close and open as normal. You shouldn't need to run as admin more than once. –  Dan Atkinson May 2 '13 at 9:46

Try entering the full path to java.exe while using SQL Developer. For example:

c:\app\shellperson\product\11.1.0\db_1\jdk\jre\bin\java.exe
share|improve this answer

Resolved. It didnt work for me but after spending lot of time , here is what what I did to fix it.

1) Open the file

..\sqldeveloper\sqldeveloper\bin\sqldevloper.conf 

and add the following line to set jdk path:

SetJavaHome C:\Program Files\Oracle\11g\product\11.1.0\client_1\jdk

If it don’t allow you to save the file, copy whole sqldeveloper folder to a different location where you have write access to modify this file.

2) Run sqldeveloper.exe (from the new place if you moved the folder out from oracle folders) as administrator and enter the jdk path that comes with your oracle installation:

C:\Program Files\Oracle\11g\product\11.1.0\client_1\jdk\bin

It should work then... hope it will help you save hours. - snehal

share|improve this answer

If you are in 64 bit environment, you need to install the latest java 6 SE for 32 bit and use that (oracle calls these versions i586 eg, Jdk-6u45-windows-i586.exe).

share|improve this answer

Check your sqldeveloper.conf file. It contains:

SetJavaHome ../../jdk

This means when SQL Developer starts up it will look in the ../../jdk folder for java.exe.

Once you've installed a version of JDK, copy the folder to ../../jdk location relative to the sqldeveloper.conf file (which you can find in /bin folder).

/installed folder
    ...
    /dataminer
    /ide
    /javavm
    /jdk   <== create this and copy jdk stuff here
    ...
    sqldeveloper.exe

...

then you won't be prompted with the question.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.