Creating an Apache Derby Connection Profile

Create a connection profile to connect to Apache Derby.

1. In Data Source Explorer, right-click Databases and select New.
2. Enter the letter d to filter the Connection Profile Types list.
3. Select Derby.
4. (Optional) Change the Name from the system-provided default, and/or enter a Description, and click Next.

   You must change the name if a connection profile already exists with the same name.

5. Select a Derby driver.

   The Properties tabs populate with default template information for the selected driver.

6. (Optional) Add or modify the Properties information in the Connection or Other Properties tabs.
   1. Click Create Database (If Required) to create a database, if the one you indicated in the Database Location does not exist.
   2. Click Upgrade Database to Current Version if you are using an older version of a Derby database and want to use the version that matches the driver version.
   3. Click Save Password to save the password in the workspace metadata for the database server login.

      Unsaved passwords persist only for the current session.

   4. Select Connect When the Wizard Completes to connect to the database server once you finish defining this connection profile.
   5. Select Connect Every Time the Workbench Is Started to automatically connect to the database server using this connection profile when you launch Eclipse.
   6. Click Test Connection to ping the server and to verify that the connection profile is working.
7. (Optional) Click Next to view Summary information.
8. Click Finish to create the connection profile.