SQLDeveloper + Vista Trick

Recently I switched from Windows XP to Windows Vista, ignoring all pro’s and contra’s for upgrading my OS, I had a problem when I used SQLdeveloper.

When you edit a package and try to scroll between the code then it became unreadable:

After some research I came across an excellent tip on the java2go blogspot.

I’ll give the short version here under but please visit them for more info:

– Download the latest java jdk

– Edit the file (C:\sqldeveloper\ide\bin\ide.conf) and add the following:
# setting maximum heap to 256 MB
AddVMOption -Xmx256M

#setting keepWorkingSetOnMinimize
AddVMOption -Dsun.awt.keepWorkingSetOnMinimize=true

– Edit the file (C:\sqldeveloper\ide\bin\jdk.conf) and add the following:
SetJavaHome C:\Program Files\Java\jdk1.5.0_16
(refering to the jdk you downloaded

I restarted my SQLdeveloper and all my problems were gone!


18 thoughts on “SQLDeveloper + Vista Trick

  1. Thanks for the tip! I hope you decided to run Vista 64 bit, otherwise you may end up disappointed over time due to the inadequate memory handling of the 32 bit version.

  2. Vista 64 is only relevant if you have over 3GB of physical RAM. It also adds a whole new level of security, and will ultimately be the architecture Microsoft uses.

  3. I'm also running SQL Dev on Vista (over 12 months now). Can you test something for me? Go into Tools > Preferences > Environment and change the "Look and Feel" from "Oracle" to "Windows". Restart SQL Dev and let me know if you notice any difference in performance. If possible, can you drop me a note on my blog or an email if you have my email address?

  4. tylermuth, it seems when changing to that option the performance increases. I immediately saw it when restaring SQL Dev.Great tip!

  5. OK, I’m not crazy then 😉 I saw a DRAMATIC increase in performance when changing to that option. I’ll ping Kris Rice (SQL Developer, Development Manager) on this and see what he has to say.

  6. There’s a small amount of issues for SQL Developer documented on the Oracle Wiki, including this one. If you find any other issues and you blog about it, an addition to the Wiki page would be appreciated.Cheers,CM.

  7. I was experiencing the same on Vista x64. Installed JDK 64bit but didn’t work. Installed JDK 32bit and it worked all fine. It’s actually faster than before!Thanks for the post.

  8. FYI I found that adding the keepWorking SetOnMinimize did not help. However adding the following did:AddVMOption -Dsun.java2d.noddraw=true

  9. Olivier – Just wanted to offer a big thanks for posting this. I've been getting more and more annoyed lately at the garbled text issue & performance issues. The solutions identified, along with changing the Look and Feel to Windows as mentioned by Tyler Muth, definitely seems to help a good bit on my Vista machine. It made my day.

  10. Jon V,Your suggestion to use AddVMOption -Dsun.java2d.noddraw=true is all that I needed to prevent the text-scrolling smear problem. Thanks.

  11. Thnks a lot..But,I am getting a problem while editing sql worksheet in SQL developer.None of the keys(Backspace,enter,right arrow,left arrow) are working.Can u send me a solution for the same..

  12. Hey pradeep,

    Can’t really say that I know a solution but try to reset your keys under Tools -> Preferences.

    Are you working with the latest version of SQLDveloper?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

About Olivier Dupont