This content has been marked as final. Show 16 replies
Supposedly "Java SE 7 is strongly compatible with previous versions of the Java platform". See the official discussion of compatibility here:
That said, if one configures SQL Developer 3.0.04 to run under jdk1.7.0, a warning dialog comes up with the following disclaimer asking if you wish to proceed:
You are attempting to run with Java 1.7.0
Running this product is supported with a minimum Java
version of 1.6.0_04 and a maximum version less than 1.7,
This product will not be supported, and may not run correctly
if you proceed. Continue anyway?
So no guarantees from Oracle here. I haven't heard which SQL Developer version will officially support jdk1.7.0.
To try this out, you need to adjust your configuration as follows. For example on Windows do something like:
1) The sqldeveloper.conf file must SetJavaHome, e.g., SetJavaHome C:/Program Files/Java/jdk1.7.0
2) copy "C:\Program Files\Java\jdk1.7.0\bin\msvcr100.dll" to the same directory as sqldeveloper.conf.
Have fun (if you dare),
SQL Developer Team
I already tried running SQL Developer using JDK 7. It starts, you can connect to databases and execute queries. However, I noticed that there is no smooth fetching of the next 50 results in the result pane, if there are more than 50 entries. It turned out to be such an important feature for me, that I went back to JDK 6.
Thanks for the feedback. I'm sure a supported/certified release for Java 7 will function smoothly when it comes out, but I have no idea when that will happen. Even though SQL Developer more or less runs on the new JVM, the current code base doesn't compile under it. No doubt minor differences in the language syntax are at fault, but those should be easy to deal with.
SQL Developer Team
You can increase the 50 records to something bigger by setting:
prefrences - database - advanced - SQL Array Fetch Size
I can live with 500 records - if i need to see more than 500 records it means that the problem (thus query) is not defined adequately, so need to rethink the problem and narrow down the result set.
However, I have another "gotcha" running SQL Developer with JDK 7: I try to use the mouse as little as possible by using keyboard shortcuts. When I'm working in the SQL Worksheet and want to navigate to connections tree, I type ALT+v (to get the View menu open) and then c (shortcut to "Connections"). But when I press the ALT+V besides opening the View menu there appears a letter "v" in the SQL Worksheet, where the cursor is positioned - the same as if I pressed just "v". This is a source of numerous errors and bugs (unintentional "v"s everywhere) and a big time consumer. This doesn't happen with JDK 1.6.X
I use SQL Developer on Fedora Linux 64bit
I hoped that combination of jdk 1.7_03 and sqldeveloper 3.1 would resolve the problem of unintentional leftovers from keyboard navigation, but unfortunately - it isn't so.
Also the fetching past "array fetch size" records problem (yes, the ctrl+end works, then you can scroll with page up/down, too) is still there.
Hope this get fixed soon (especially the first one), because sqldev 3.1 runs faster and smoother with jdk 1.7_03 than with 1.6_3X. It also keeps RAM consumption under (somewhat resonable) 550MB - even with heavy usage over entire week with no restart with these additions in sqldeveloper.conf :
The last two options :
+UseConcMarkSweepGC should be used only on multicore computers and
+UseCompressedOops should be used only on machines with 64bit operating systems
I'm no java expert, so these settings may be improved. They just work for me.
Thanks for the feedback on which JVM options work best for you. Some are the same as listed in the second link referenced in the following post:
Re: Export to Excel Hangs
Please note that there is nothing new on the Java 7 front for SQL Developer. The product is still being built and tested with Java 6 for the foreseeable future.