Configuring data sources

A data source maintains a pool of available connections that EAServer components use to interact with third-tier data servers. You must configure data sources for the specific user and database combinations used by your components. A data source entry improves performance by eliminating the overhead associated with setting up a connection when one is required. Create as many data sources as you need.

If you define two data sources that use identical values for server, user, and password, and your application requests a connection using only these values, EAServer returns the first match that is found.

Table 4-2 describes the predefined data sources. Use the Management Console to modify the definitions of these data sources and create new data sources.

Table 4-2: Predefined data sources

Data source name

Description

default

The default data source, which is configured to connect to a Sybase_ASA database type.

cluster.db

Initially, the same configuration as the default data source; you may want to customize to use with a server cluster.

JavaCache

An alias for default.

message.db

Initially, the same configuration as the default data source; you may want to customize to use for the message service.

session.db

Initially, the same configuration as the default data source; you may want to customize to use for a session.

tx_manager

Initially, the same configuration as the default data source; you may want to customize for the transaction manager.

StepsCreating a new data source

  1. In the Management Console, open the Resources folder.

  2. Highlight Data Sources, right-click and select Add.

  3. Enter the data source name in the wizard.

    Data source names are limited to one word, which can contain letters, numbers, and underscores. Names are case-sensitive.

Data source entries appear on the right side of the window in the Management Console when you highlight the Data Sources folder on the left side of the window.

NoteYou must refresh a data source before any changes to the data source properties take effect, and you should test the connection with ping before trying to access it from components.

StepsDeleting a data source

  1. Expand the Data Sources folder.

  2. Highlight the data source to delete, right-click, and select Delete.

  3. In the wizard, select Finish.

StepsConfiguring a data source

You cannot modify the name of an existing data source.

  1. Expand the Data Sources folder.

  2. Select the data source to configure.

  3. In the right pane, enter the data source properties on these configuration tabs:

    To save your changes, select Apply; to restore the initial values, select Reset.