Primarily, can any of you confirm that I need JDK (or J2SE SDK as the error message states) - and not just JRE as it is stated on the download pages on OTN?
I have just downloaded "SQL Developer Data Modeler" w/o JRE. Primarily because I already have JRE 1.6.0_17 installed, so downloading it bundled should not be necessary -- and secondly I would not want to risk intefering with the automatic software updating of JRE done by my company's IT support staff.
I may well be a complete Java amateur, but shouldn't JRE be sufficient, if you only want to run java apps?
I've only installed SQL DEVELOPER and without a JDK, it wouldn't run at all. If SQL Modeler is the same way with JRE (reading the release notes), the modeler stays self-contained in the same directory you unzip to. Unless you have no rights to even copy fiiles to your pc, I don't know what other problems you could have.
Indeed I see that this (having JDK bundled as subdirectories - not as a complete, separate windows installation) is the case with my installation of SQL Developer as well -- unfortunately not with the right version though. ;o)
I guess I will try downloading the bundled version of SQL Developer Data Modeler and see if that is the case here too.
But just like "-K-" I still do not see why you need JDK for it to run - unless you need to do development or debugging.
I get the prompt: "Enter the full pathname for java.exe:"
I enter: "C:\Program Files\Java\jre6\bin\java.exe"
Then I get the error message: "Cannot find a J2SE SDK installed at path: C:\Program Files\Java\jre6."
Which I interpret as JDK being a prerequisite for running the application -- though I do not understand why.
Looking back at the download I realize that I have version 2.0.0-570 and not the new 2.0.0-584. I will try that tomorrow.
That must have been inherited by SQL Developer. With sqldev you can force a Java to be used, by setting it in \sqldeveloper\bin\sqldeveloper.conf. Try finding the equivalent file for Data Modeler and add this:
JRE is enough for Data Modeler to work however there is a restriction in datamodeler.exe which comes from JDeveloper. If you don't want JDK, then you can use datamodeler.bat - in this case you need Java bin directory to be listed in PATH environment variable.