How can I run Oracle SQL Developer on JDK 1.6 and everything else on 1.7?

java sql oracle oracle-sqldeveloper
Xonatron picture Xonatron · Oct 24, 2011 · Viewed 64.2k times · Source

How can I run Oracle SQL Developer on a version of Java it supports (1.6) while running Java 1.7 for everything else?

I can install both JDK's on my system, but I'm concerned with changing environment variables and having it affect more than just SQL Developer. Curious if there's elegant solutions to this.

I am having issues with SQL Developer (running off JDK 1.7) only returning 50 rows. <-- Feel free to address this specific issue as well. EDIT: The problem is not that it returns only 50 rows, this is standard, the problem is the inability to scroll down to see more rows on demand.

Answer

a_horse_with_no_name picture a_horse_with_no_name · Oct 24, 2011

Just install Java7 as the default JDK in your system.

You can tell SQL Developer to use a specific JDK by editing the file sqldeveloper/bin/sqldeveloper.conf and add the line:

SetJavaHome /path/to/jdk

If you are on Windows, you need to specify a correct Windows path of course:

SetJavaHome c:\Java\jdk16

Update after two comments:

The above answer was added when SQL Developer 3.x was the current version. Apparently this does not work any longer for SQL Developer 4.x. It seems that SQL Developer 4.0 just scans the PATH to find a suitable JRE

Related questions

Using setDate in PreparedStatement

In order to make our code more standard, we were asked to change all the places where we hardcoded our SQL variables to prepared statements and bind the variables instead. I am however facing a problem with the setDate(). Here …

Read More
Cleanest way to build an SQL string in Java

I want to build an SQL string to do database manipulation (updates, deletes, inserts, selects, that sort of thing) - instead of the awful string concat method using millions of "+"'s and quotes which is unreadable at best - there …

Read More
JDBC ResultSet: I need a getDateTime, but there is only getDate and getTimeStamp

I would like to get the DATETIME column from an Oracle DB Table with JDBC. Here is my code: int columnType = rsmd.getColumnType(i); if(columnType == Types.DATE) { Date aDate = rs.getDate(i); valueToInsert = aDate.toString(); } else if(columnType == Types.…

Read More