I love SQL Developer. I love the SQL History feature.
However, I'm distraught. Recently, the SQL History stopped loving me back. It just won't display -- either from F-8 or from the View menu. From what I can tell, it looks like the history files are still being written. I've looked through all of my settings and can't see anything amiss.
I could really use some help if anyone knows the magic word to make my History reappear.
Deleted C:\Documents and Settings\<me>\Application Data\SQL Developer\system3.2.20.09.87\o.ide.184.108.40.206.37.59.48\windowinglayout.xml (sorry, I should have mentioned that I'm stuck in XP).
Still no love. I opened SQL Developer and still can't see the SQL History, either through F-8 or through the View menu. It just ignored me. It's like it just doesn't care anymore :)
No messages in the console window. Again, I felt so ignored.....
So, I looked at the possibility of a history files/indexes being bad. Since I don't totally know how it works, I just guessed based on file and directory names. There's not much to lose at this point, so why not?
I deleted all of the files in C:\Documents and Settings\<me>\Application Data\SQL Developer
I also cleaned out all of the files in all of the directories under C:\Documents and Settings\<me>\Application Data\SQL Developer\system3.2.20.09.87\.history
I may not have needed to do both steps (I got impatient), but that did the trick!! SQL History loves me again!!