Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




Eclipse Data Tools Platform Guide
Previous Page Home Next Page

Connection Profile Derby JDBC Connection Properties

Edit the properties of a Derby JDBC connection profile.

Property Description
Drivers Select a driver from the list. If an appropriate driver definition does not exist, you can create one.
  • Select New Driver Definition button New Driver Definition to create a new driver definition.
  • Select Edit Driver Definition button Edit Driver Definition to edit an existing driver definition.
Database Location Enter the fully qualified path to the database, or click Browse. You can select an existing database or create a new one.
User Name User ID associated with the connection profile.
Password Password for the database server login.
URL Displays the URL address for the profile.
Create Database (If Required) Creates a database, if the one you indicated in the Database Location does not exist.
Upgrade Database to Current Version Select if you are using an older version of a Derby database and want to use the version that matches the driver version.
Save Password Save the password for this connection profile. Passwords persist only for the current session. If you do not save your password and exit the workbench, you have to enter it when trying to connect to the database server via the connection profile for the new session.
Note: Whether you want to save your password depends on your organization's security policy. Passwords are saved in the workspace metadata in the ServerProfiles.dat file with minimal encryption.
  1. In the text box, specify connection properties using the KEY=value format, or choose from the drop-down list, and click Add.

    For example, DYNAMIC_PREPARE=true.

  2. Use the Up, Down, Remove, and Clear All buttons to delete or change the order of the connection properties.
Test Connection Ping the server and verify that the connection profile is working.

  Published under the terms of the Eclipse Public License Version 1.0 ("EPL") Design by Interspire