Creating a database connection is often a necessary task when creating a Java application. For example, you might want to use straight-forward JDBC to connect to a database in a standalone application, or you might be creating an ADF business object if you are using the Oracle Fusion stack.
To create a database connection with JDeveloper, you’ll need to perform these steps:
- Ensure the database is up and running and can be access through the network. If you are using an Oracle database, be sure the listener is running.
- Go to the Application Navigator and right-click on the Connections node. Create a new connection – this may be either an application connection or an IDE connection that is used by multiple applications.
- Provide the connection information (IP address or host name and port number) and credentials.
- After creating the connection, test it by going to the Application Resources window and expanding the nodes until you see your connection.