Where does Oracle SQL Developer store connections?

Question

I have an application that I can't get connected to my Oracle Database 11g Express Edition. I created a test database in this edition, and I can connect to the database fine using Oracle SQL Developer, create tables, views etc. However, I'm having a hard time getting connected via my application. Where is the connection information? In what file? I wanted to compare my connection info with what is set up in the SQL Explorer's file. I found all the *.ora files and renamed them to see if I could find what file (through the process of elimination) the connections were stored in, but I wasn't successful. Any help would be appreciated.

Answer 1

It was in a slightly different location for me than those listed above

\Users\[user]\AppData\Roaming\SQL Developer\system3.2.20.09.87\o.jdeveloper.db.connection.11.1.1.4.37.59.48\connections.xml 

Answer 2

Assuming you have lost these while upgrading versions like I did, follow these steps to restore:

1. Open SQL Developer
2. Right click on Connections
3. Chose Import Connections...
4. Click Browse (should open to your SQL Developer directory)
5. Drill down to "systemx.x.xx.xx" (replace x's with your previous version of SQL Developer)
6. Find and drill into a folder that has ".db.connection." in it (for me, it was in o.jdeveloper.db.connection.11.1.1.4.37.59.48)
7. select connections.xml and click open

You should then see the list of connections that will be imported