Setting Derby properties for a project

Properties relating to Apache Derby can be specified for any project which has had the Apache Derby nature added to it. The two categories of properties available to change are the Network Server and Derby System properties.

Network Server Properties

By starting the Derby Network Server using the default values the server runs on the localhost, which is the host running Eclipse, on port 1527.

The value used for the Network Server host name impacts the ability of remote hosts to connect to the Network Server. If the Network Server Host value in the Apache Derby Properties for the project is set to localhost, only clients running on the host where Eclipse is running can connect to the network server. If an ip address or hostname (other than the name 'localhost') is used, client applications running on other hosts can connect to the Derby Network Server. For additional information about starting the Derby Network Server see the Derby Server and Administration Guide. The section called Starting the Network Server explains the effect of setting the value for the hostname differently.

If connections from other hosts is allowed, it is recommended to run under the Java security manager and enable user authentication prior to starting the Derby Network Server.

• Network Server Port - default value of 1527
  
  Valid values for this field are:
  • Any port number not currently used by another process to listen on
    
    
• Network Server Host - default value of localhost
  
  Valid values for this field are:
  • localhost
  • The ip address of the host running Eclipse
  • The host name of the host running Eclipse
  • The ip address of 0.0.0.0 (to listen on all interfaces)

Derby System Properties

derby.system.home refers to the file system directory where the Derby database system will look for databases when Derby is started. Setting this property allows for ease of use when specifiying a JDBC connection URL to a Derby database which is not in the current directory. For additional information on derby.system.home refer to the Tuning Derby guide.

Derby System Property values

• derby.system.home - default value of '.', the current project directory
  
  Valid values for this field are:
  • A directory path on the local host. Either an existing directory or a new one which has not yet been created.

Changing the default Apache Derby properties for a project

• With the Java project active in the Package Explorer or Navigator view, select the menu item Project, Properties.

• The list of properties available to modify for the project appears. Select the Apache Derby item in the list.
  
  
• Make any of the desired changes to the Apache Derby settings.