blocks|key|526917|text|对于我来说，它所在的位置与上面列出的位置略有不同|type|unstyled|depth|inlineStyleRanges|entityRanges|data|526918|\Users\[user]\AppData\Roaming\SQL+Developer\system3.2.20.09.87\o.jdeveloper.db.connection.11.1.1.4.37.59.48\connections.xml|code-block|syntax|javascript|526919|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

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

<pre><code>\Users\[user]\AppData\Roaming\SQL Developer\system3.2.20.09.87\o.jdeveloper.db.connection.11.1.1.4.37.59.48\connections.xml
</code></pre>

blocks|key|526877|text|如果没有找到connections.xml，那么在SQLDeveloper的Connections视图中右键单击Connections，然后选择Export+connections。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|526878|entityMap^0|6|F|1K|B|20|I|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|O|8|@]|D|@]|E|$]]]|G|$]]

If you don't find the <code>connections.xml</code> then right-click on <code>Connections</code> in the Connections view of SQLDeveloper, and choose <code>Export connections</code>.

blocks|key|743278|text|它存储在下面一个名为connections.xml的文件中|type|unstyled|depth|inlineStyleRanges|entityRanges|data|743279|\Users\[User]\AppData\Roaming\SQL+Developer\System\|code-block|syntax|javascript|743280|当我重命名该文件时，我所有的连接信息都消失了。我把它重新命名了，然后一切都回来了。当我查看XML文件时，我发现了测试连接别名、端口、用户名、角色、身份验证类型等。|743281|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

It is stored in a file called connections.xml under 

<pre><code>\Users\[User]\AppData\Roaming\SQL Developer\System\
</code></pre>

When I renamed the file, all my connection info went away. I renamed it back, and it all came back. When I viewed the XML file, I found both test connection aliases, ports, usernames, roles, authentication types, etc.

blocks|key|743321|text|在某些版本中，它将其存储在|type|unstyled|depth|inlineStyleRanges|entityRanges|data|743322|<installed+path>\system\oracle.jdeveloper.db.connection.11.1.1.0.11.42.44
\IDEConnections.xml|code-block|syntax|javascript|743323|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In some versions, it stores it under

<pre><code>&lt;installed path&gt;\system\oracle.jdeveloper.db.connection.11.1.1.0.11.42.44
\IDEConnections.xml
</code></pre>

blocks|key|526984|text|对于OS+X，我的connection.xml文件在|type|unstyled|depth|inlineStyleRanges|entityRanges|data|526985|/Users/<username>/.sqldeveloper/system<sqldeveloper_version>/o.jdeveloper.db.connection.<oracle_version?>/|code-block|syntax|javascript|526986|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For OS X my connection.xml files are in

<pre><code>/Users/&lt;username&gt;/.sqldeveloper/system&lt;sqldeveloper_version&gt;/o.jdeveloper.db.connection.&lt;oracle_version?&gt;/
</code></pre>

blocks|key|526931|text|我找到了我的|type|unstyled|depth|inlineStyleRanges|entityRanges|data|526932|C:\Users\<user>\AppData\Roaming\SQL+Developer\system2.1.1.64.45\o.jdeveloper.db.connection.11.1.1.2.36.55.30\connections.xml|code-block|syntax|javascript|526933|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I found mine in 

<pre><code>C:\Users\&lt;user&gt;\AppData\Roaming\SQL Developer\system2.1.1.64.45\o.jdeveloper.db.connection.11.1.1.2.36.55.30\connections.xml
</code></pre>

blocks|key|743443|text|SqlDeveloper将所有连接存储在一个名为|type|unstyled|depth|inlineStyleRanges|entityRanges|data|743444|connections.xml|code-block|syntax|javascript|743445|在windows+XP中，您可以在以下位置找到该文件|743446|C:\Documents+and+Settings\<username>\Application+Data\SQL+Developer\systemX.X.X.X.X\o.jdeveloper.db.connection.X.X.X.X.X.X.X\connections.xml|743447|在Windows+7中，您可以找到它的位置|743448|C:\Users\<username>\AppData\Roaming\SQL+Developer\systemX.X.X.X.X\o.jdeveloper.db.connection.X.X.X.X.X.X.X\connections.xml|743449|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

SqlDeveloper stores all the connections in a file named 

<pre><code>connections.xml
</code></pre>

In windows XP you can find the file in location

<pre><code>C:\Documents and Settings\&lt;username&gt;\Application Data\SQL Developer\systemX.X.X.X.X\o.jdeveloper.db.connection.X.X.X.X.X.X.X\connections.xml
</code></pre>

In Windows 7 you will find it in location

<pre><code>C:\Users\&lt;username&gt;\AppData\Roaming\SQL Developer\systemX.X.X.X.X\o.jdeveloper.db.connection.X.X.X.X.X.X.X\connections.xml
</code></pre>

blocks|key|527012|text|以一种更简单方式打开搜索窗口并搜索connection.xml时，右键单击该文件并选择打开文件/文件夹位置。获得connection.xml后，尝试通过右键单击CONNECTIONS将其导入到SQLDeveloper中。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|527013|entityMap^0|H|E|1K|E|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

In a simpler way open search window and search for <code>connection.xml</code> gives a right click on that file and select open file/folder location.
Once you get that <code>connection.xml</code> try to import it into SQLDeveloper by right clicking to CONNECTIONS.

blocks|key|743578|text|对于macOS|type|unstyled|depth|inlineStyleRanges|entityRanges|data|743579|/Users/joseluisbz/.sqldeveloper/system18.1.0.095.1630/o.jdeveloper.db.connection/connections.xml|code-block|syntax|javascript|743580|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

for macOS 

<pre><code>/Users/joseluisbz/.sqldeveloper/system18.1.0.095.1630/o.jdeveloper.db.connection/connections.xml
</code></pre>

blocks|key|527041|text|在linux系统上：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|527042|~/.sqldeveloper/system<sqldeveloper_version>/o.jdeveloper.db.connection/connections.xml|offset|length|style|CODE|527043|entityMap^0|0|0|2F|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

On linux systems:

<code>~/.sqldeveloper/system&lt;sqldeveloper_version&gt;/o.jdeveloper.db.connection/connections.xml</code>

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.

Where does Oracle SQL Developer store connections?

身份验证

数据库

Windows

我有一个应用程序无法连接到我的Oracle Database 11g Express Edition。我在这个版本中创建了一个测试数据库，我可以使用Oracle SQL Developer很好地连接到数据库，创建表，视图等。然而，我很难通过我的应用程序连接到数据库。连接信息在哪里？在什么文件里？我想将我的连接信息与SQL Explorer文件中设置的信息进行比较。我找到了所有的*.ora文件，并对

问Oracle SQL Developer将连接存储在哪里？
EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Oracle SQL Developer将连接存储在哪里？EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Oracle SQL Developer将连接存储在哪里？
EN