« Why soldiers should use Linux in Iraq…
Post number 1000 »

SQL Developer 1.5 connection setting lost

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

Oracle SQL Developer

Monday, May 12th, 2008 at 11:09 am.
Filed under General.
Subscribe to RSS 2.0.
Leave a comment or trackback.

10 Responses to “SQL Developer 1.5 connection setting lost”

  1. dp
    June 2nd, 2008 at 8:26 am

    this totally worked for me thanks so much

  2. Arun
    June 3rd, 2008 at 6:27 am

    You are welcome. :)

  3. Matty
    July 2nd, 2008 at 12:09 am

    Thankyou so much - this was driving me crazy!!

  4. Arun
    July 3rd, 2008 at 6:35 am

    You are welcome.

  5. Didi
    July 21st, 2008 at 9:39 am

    Hi,
    I tried this solution and many others stated on the Oracle Forum.
    But nu luck.. Didn’t work for me..

    Any other ideas ? I really like this tool but those lost connections are driving me crazy..

    Didi.

  6. Arun
    July 21st, 2008 at 10:50 am

    I have no other solution. The saved connections were gone when I upgraded to SQL Developer 1.5.1 a week back. I then went back and edited the conf file as stated above and the connections are back. i’m not sure why it’s not working for you. I also don’t understand why Oracle didn’t fix this issue when they released 1.5.1.

  7. Didi
    July 22nd, 2008 at 9:46 am

    Thanks for you reply.
    Did you also add a new connection and restart ?
    I must say that only when I delete everything under AppData\SQL Developer and then restart sql developer and import my connections, it works.
    But when I add a new connection and then restart, everything gone again..
    Hopefully they have a fix soon (doesn’t look promising since it’s been like this for quite a while…).

    Didi.

  8. Didi
    July 22nd, 2008 at 11:27 am

    Hi,
    I thought I would give it one more shot of making this work and it looks like my efforts paid off.. It finally works..
    Apparently SQL Developer also looks at the JDK you’re using (at least with me it did..).
    When using JDK 1.6 Update 5 it doesn’t work.
    So I installed JDK 1.6 Update 7 and also SQL Developer 1.5.1 and that does the trick.
    Importing connections and also creating new connections seem to work perfectly once again..

    Didi.

  9. Arun
    July 22nd, 2008 at 12:12 pm

    Good to know it worked. :)
    I lost my connection when I upgraded to 1.5.1. I then had to recreate and edit the config file to get it working. They need to fix a lot in this product before it can compete with Toad and other 3rd party tools.

  10. Luke
    August 14th, 2008 at 10:46 am

    Arun…u da man!

Leave a Reply