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