About Database Connections

Define and manage connections to external data sources using the Create Connection wizard, and store them in the Connection Navigator. All defined connections are accessible to any workspace or project.

When you delete a connection, JDeveloper does not warn you that project may be dependent upon it. For this reason, it is best to use caution when deleting connections.

Note: You can create tables and other database objects, or model them, using offline database definitions in the Project or Application Navigators. For more information, see Working with Offline Database Definitions.

Connection Descriptor Properties Location

The file system location for the connection descriptor definition information is

<jdev_install>/system<release_and_build_number> /IDEConnections.xml

where <jdev_install> is the root directory in which JDeveloper is installed.

Connection Properties Deployment

A connections.xml file is included with JDeveloper deployments. This file contains the connection information necessary for deployment and the runtime connection execution.

The Deploy Password checkbox in the Create Connection wizard determines whether the password is included in the deployed connections.xml file. Select the checkbox to add the password information to the deployed connections.xml file. If this checkbox was not selected for the deployed connection, a runtime user of that connection must enter a valid user name and password for the connection. Note that the password is stored in clear text on disk.