This content has been marked as final. Show 6 replies
Not much to go on here. More details would be helpful, such as...
1. SQL Developer version and OS.
2. JDK version. The latest jdk1.6.0 update is recommended. Avoid the jdk1.7.0 updates at this time.
3. The connection type such as Basic, TNS, etc. Or is it a Cloud Connection?
4. Do queries still yield a frozen/unselectable results grid from Run Statement even after exiting and restarting SQL Developer?
5. Did you try resetting all your settings by ...
a. Export your connections and exit SQL Developer b. Delete (e.g., on Windows 7) the C:\Users\<username>\AppData\Roaming\SQL Developer\systemn.n.n.n.n folder for your version. c. Restart SQL Developer.
SQL Developer Team
In response to your questions, here is what I have:
SQL Developer 3.2.10.09
Windows 7 64 bit
jdk 1.7.0 - I can try installing jdk1.6.0 if necessary but it worked prior on this version of Java.
Yes, queries yield a frozen/unselectable results after exiting and restarting SQL Developer
I exported my connections and re-imported them after upgrading to this version (problem originated in a slightly earlier version.
I searched for path above but do not have \AppData folder or the other folders referenced above.
The path mentioned in (b) of my earlier post depends on your environment. It may help if you read the Help, but even that refers to an earlier version of Windows (XP). See the SQL Developer user preferences table row in
SQL Developer Concepts and Usage > SQL Developer Preferences > Location of User-Related InformationYou also may wish to upgrade to the latest version: 3.2.20.09.87
My MIS department had locked down those files. Once I was granted access, I deleted the files you mentioned and also downloaded jdk 1.6.0 and now everything is back to normal. Thanks again for your help.
Edited by: 971062 on Nov 16, 2012 6:08 AM
I have the same issue after resetting all my sqldeveloper settings. Here is what I have:
SQL Developer 3.2.20.09.87
Windows 7 64 bit
and queries yield a frozen/unselectable results after exiting and restarting SQL Developer
The original poster's issue was related to lack of write access to whatever user settings home his installation pointed/defaulted to.
Your issue could be the same even though you say you reset your settings (by deleting them):
1. Possibly you don't have write access and only thought you deleted the settings. I made that mistake before -- ran delete from the command line, assumed it worked, and didn't even look back at the console for any error message!
2. Possibly you have write access, but that access is not entirely stable -- perhaps the settings home is on a removable or networked drive?
If either of these is true, you can override the settings home:
Re: SQL Developer Error Creating User Home