Posted 03 Jun 2009 — by Arun
Category Oracle
I like Oracle SQL Developer even though it’s slightly bulkier and slower to start than Toad (with less functionality and buggy). I found one annoying problem with SQL Developer. If you are running a query in the SQL Worksheet and the query is taking sometime to return the rows, you can’t open another worksheet until the query is done. If you try to open another worksheet, you’ll get a message saying “Connection currently busy. Try again or Abort”. What’s the purpose of multiple worksheets if you can’t work on more than one simaltaneously? I hope they fix this soon.
Technorati Tags: Oracle, SQL Developer, Worksheet, Toad
Share on Facebook
Posted 20 May 2009 — by Arun
Category Oracle
I use SQL Developers for my development work. All of a sudden, the Backspace key, CTRL key, Delete key and other function keys stopped working in the SQL worksheet. I don’t remember doing anything out of ordinary, but those keys stopped working. I then Googled and found a solution. All you have to do is click on Tools menu – select Preferences, click on Accelerators on the left side, click on Load Preset button on the right, select Default (screenshot below), click OK and click OK again to close the preference window. All keys should work fine now.
Technorati Tags: Oracle, SQL Developer, Backspace, CTRL
Share on Facebook
If you work with Oracle Database, then you might have heard about SQL Developer. SQL Developer is a free graphical tool for database development. I use this for some of my Oracle work. It’s a decent tool and it’s free.
When I upgraded my SQL Developer to the latest version (1.5.0.53), I lost my database connection settings. The settings worked the first time I created them in the new version, but it was lost the next time I opened the SQL Developer. When I tried to recreate, the save or connect key did not work. I finally fixed it as per the advise given in the OTN forum. All you have to do is edit the sqldeveloper.conf file located under C:\Program Files\sql developer installation folder\sqldeveloper\bin using notepad or wordpad and add the following lines to the end of the file. Save and restart SQL Developer. You should see your connection settings back.
AddJavaLibFile ../../lib/java/api/jaxb-api.jar
AddJavaLibFile ../../lib/java/api/jsr173_api.jar
AddJavaLibFile ../../j2ee/home/lib/activation.jar
AddJavaLibFile ../../lib/java/shared/sun.jaxb/2.0/jaxb-xjc.jar
AddJavaLibFile ../../lib/java/shared/sun.jaxb/2.0/jaxb-impl.jar
AddJavaLibFile ../../lib/java/shared/sun.jaxb/2.0/jaxb1-impl.jar
Share on Facebook
