11 June 2009

SQL Developer: Backspace not working properly

Nowadays I use SQL Developer on a daily basis, and I like it more and more. But every now and then something rears its ugly head, and that can be annoying.

Just this morning I had one of those encounters. The "Backspace"-key stopped working. Not only the backspace, but DELETE, ENTER, navigation with the arrow keys...

I tried re-installing SQL Developer, reboot the computer... no success.

"Google is your friend" at times like these. One of the first hits I came across was this blog post and that solved my problem.


The only thing you need to do is go from the menu "Tools -> Preferences" and in the Preferences window to "Accelerators", push the button "Load Preset" and pick the Default. And that's it.

Now it works like a charm again.
Geplaatst door op
Labels:

32 comments:

  1. Saravanan SSeptember 9, 2009 at 11:22 AM

    Thanks a lot, for posting this meassage. it helped me at a great time (i was facing this problem very often) since am a regular user of Oracle SQL develper.

    thanks agian.....

    ReplyDelete
  2. Alex NuijtenSeptember 9, 2009 at 11:41 AM

    You're welcome. If you had this problem often, how did you solve it? Are there any other options that you could share? The downside of this approach is that your custom accelarators are also overwritten...

    ReplyDelete
  3. AnonymousOctober 14, 2009 at 2:49 PM

    Excellent! My arrow keys stopped working months ago (but the backspace and other special keys were OK). Since I did not have any customized accelarators, following your instructions got my arrow keys back. thank you.

    ReplyDelete
  4. AnonymousNovember 10, 2009 at 4:38 PM

    Just another "thanks". Had this same problem, and your fixed fixed it!

    Thanks again.

    ReplyDelete
  5. AnonymousNovember 11, 2009 at 7:39 AM

    Thanks for the tip. It solves my problem, too

    ReplyDelete
  6. AnonymousDecember 21, 2009 at 9:17 PM

    I am having the same issue with SQL Server Management Studio. Backspace, delete, and arrow keys will not work in query window. Do you have a solution for this?

    ReplyDelete
  7. Alex NuijtenDecember 22, 2009 at 7:57 AM

    @Anonymous: Sorry, I am not familiar with SQL Server Management Studio... Probably because it has to do with SQL Server, and not with Oracle ;)

    ReplyDelete
  8. Binoy P MathewApril 4, 2010 at 9:25 AM

    There is not Accelerators menu in SQL developer Version 2.1.1.64, So how can I resolve this issue.

    Please help.........!

    Thanks in advance.

    ReplyDelete
  9. Alex NuijtenApril 5, 2010 at 12:25 PM

    @Binoy P Matthew regarding version 2.1.1.64: You are right, they moved the Accelerators. Now it is named "Shortcut Keys", also accesible from the Tools --> Preferences menu. On the right hand side there is a "More Actions" - button with the option to "Load Keyboard Scheme". Choose the Default in the next popup window and you should be fine. Thanks for pointing this out.

    ReplyDelete
  10. UnknownJune 1, 2010 at 12:50 AM

    I am using Oracle SQL Developer 2.1.0 under Linux/CentOS 5.4. Having the same problem with arrow keys, but there is no option under "Preferences - Environment - Accelerators".
    Only "Docable Windows, Local History, Log".

    ReplyDelete
  11. UnknownJune 1, 2010 at 12:51 AM

    Ok, should have read the last post.... got it

    ReplyDelete
  12. UnknownJune 1, 2010 at 12:53 AM

    Ok, well still doesn't work... guess I'm stuck using long-hand CTRL key combinations to move cursor.

    ReplyDelete
  13. AnonymousSeptember 1, 2010 at 11:50 AM

    Thanks a lot.Now ctrl-C and CTRL-V are working good.This saves a lot of time for me.

    ReplyDelete
  14. AnonymousFebruary 1, 2011 at 9:31 PM

    Thanks so much.
    Saved My life.

    ReplyDelete
  15. eoracleappsFebruary 22, 2011 at 12:01 AM

    Thanks

    that was very helpful

    ReplyDelete
  16. AnonymousMarch 16, 2011 at 9:13 AM

    My all keys are working fine except the back space and the preset settings are not helpful. Plz help.

    ReplyDelete
  17. Alex NuijtenMarch 16, 2011 at 10:57 AM

    @Anonymous,... well, what can I say? This post was written nearly two years ago. I realize I should have put a version number in the post somewhere, but I forgot. With the current release (2.1) of SQL Developer I didn't encounter this problem, nor with the 3EA version. So, maybe download the latest and greatest release of SQL Dev?

    ReplyDelete
  18. HariJuly 30, 2011 at 5:21 AM

    https://www.logicsmeet.com/forum/19509-Oracle-SQL-Developer-Cut-Copy-Paste-Not-working.aspx

    Thanks

    ReplyDelete
  19. AnonymousFebruary 24, 2012 at 4:40 AM

    The backspace issue persists on SQL developer 3 also.
    The suggested approach is to set the keyboard scheme in preference to 'Default'

    Tools > Preferences > Shortcut Keys
    More Actions - Load keyboard scheme - Default.


    However, this also doesn't work on Win7 boxes.

    One workaround is to export the "keyboard scheme" from an instance where backspace works and import into the new sql developer :)

    ReplyDelete
  20. hollysMay 15, 2012 at 4:19 PM

    thanks man ..saved my day

    ReplyDelete
  21. GiriMay 30, 2012 at 10:10 AM

    Thanks a lot your solution worked !!

    ReplyDelete
  22. AnonymousJune 6, 2012 at 10:23 AM

    Thanks a lot... !! You suggested what i was looking for..

    ReplyDelete
  23. AnonymousJuly 4, 2012 at 8:24 AM

    This post ROCKS!!! made my task a gazillion times easier.

    ReplyDelete
  24. Abraham GonzalezJuly 20, 2012 at 3:53 PM

    Wow excellent! I was about to download again the tool.

    ReplyDelete
  25. AnonymousSeptember 12, 2012 at 4:53 PM

    Great ! I spent some minutes of my precious live with this bizarre bug until finding the solution here.

    ReplyDelete
  26. AnonymousNovember 5, 2012 at 4:38 AM

    Years later and still an awesome tip!!

    Thanks :-)

    ReplyDelete
  27. AnonymousJanuary 11, 2013 at 8:02 PM

    Thanks a lot...

    ReplyDelete
  28. UnknownJune 11, 2013 at 5:04 AM

    So glad you posted this... I'm not sure how many more times I would've tried reinstalling SQL Deeveloper before giving up, but I'm it would've easily been double-figures!

    ReplyDelete
  29. UnknownMarch 13, 2014 at 10:23 PM

    Works for me!

    ReplyDelete
  30. AnonymousOctober 10, 2014 at 7:57 PM

    thank you., it's working

    ReplyDelete
  31. UnknownSeptember 27, 2016 at 6:20 AM

    It is working...Thanks

    ReplyDelete
  32. UnknownFebruary 1, 2017 at 3:16 AM

    Thanks this helped a lot. Had to do it from Tools --> Preferences --> Key Board Shortcuts --> More Options --> Load Keyboard Schema --> select default --> Ok

    ReplyDelete

Subscribe to: Post Comments (Atom)