Use this panel to edit the properties of a data source.
Activates the test connection service for validating application connections to the data source.
Before you click Test connection, set your data source properties and click Apply.
Specifies the scope of the JDBC provider that supports this data source. Only applications that are installed within this scope can use this data source.
Specifies the JDBC provider that encapsulates the driver implementation classes to support this data source.
Specifies the display name for the data source.
Valid characters for this name include letters and numbers, but NOT most of the special characters. For example you can set this field to Test Data Source. But any name starting with a period (·) or containing special characters ( \ / , : ; " * ? < > | = + & % ' ` @ ) is not a valid name.
Data type | String |
Specifies the Java Naming and Directory Interface (JNDI) name.
Distributed computing environments often employ naming and directory services to obtain shared components and resources. Naming and directory services associate names with locations, services, information, and resources.
Naming services provide name-to-object mappings. Directory services provide information on objects and the search tools required to locate those objects.
There are many naming and directory service implementations, and the interfaces to them vary. JNDI provides a common interface that is used to access the various naming and directory services.
For example, you can use the name jdbc/markSection.
If you leave this field blank a JNDI name is generated from the name of the data source. For example, a data source name of markSection generates a JNDI name of jdbc/markSection.
After you set this value, save it, and restart the server, you can see this string when you run the dump name space tool.
Data type | String |
Specifies if this data source is used for container-managed persistence of enterprise beans.
This option triggers creation of a CMP connection factory, which corresponds to this data source, for the relational resource adapter.
Data type | Boolean |
Default | True (enabled) |
Specifies a text description for the resource.
Data type | String |
Specifies a category string you can use to classify or group the resource.
Data type | String |
Specifies the name of the DataStoreHelper implementation class that extends the capabilities of your selected JDBC driver implementation class to perform database-specific functions.
The application server provides a set of DataStoreHelper implementation classes for each of the JDBC provider drivers it supports. These implementation classes are in the package com.ibm.websphere.rsadapter. For example, if your JDBC provider is DB2®, then your default DataStoreHelper class is com.ibm.websphere.rsadapter.DB2DataStoreHelper. The administrative console page you are viewing, however, might make multiple DataStoreHelper class names available to you in a drop-down list; be sure to select the one required by your database configuration. Otherwise, your application might not work correctly. If you want to use a DataStoreHelper other than those displayed in the drop-down list, select Specify a user-defined DataStoreHelper, and type a fully qualified class name. Refer to the information center for instructions on creating a custom DataStoreHelper class.
Data type | Drop-down list or string (if user-defined DataStoreHelper is selected) |
This alias is used for database authentication at run time.
If you do not set an alias through the component-managed authentication or otherwise, and your database requires the user ID and password to get a connection, then you will receive an exception during run time.
Data type | Drop-down list |
This field is used to specify the authentication alias that should be used during XA recovery processing. If this alias name is changed after a server failure, the subsequent XA recovery processing uses the original setting that was in effect before the failure.
The database identity for the XA recovery authentication alias on a data source must have authorization to do XA recovery. Depending on the authorization schema for your installation, this level of authorization might be different from the level of authorization that the identity needs to access database tables for an application.
If the resource adapter does not support XA transactions, this field does not display. The default value for this field is derived from the selected alias for application authentication, if one is specified.
If you have defined security domains in the application server, you can click Browse... to select an authentication alias for the resource that you are configuring. Security domains allow you to isolate authentication aliases between servers. The tree view is useful in determining the security domain to which an alias belongs, and the tree view can help you determine the servers that are able to access each authentication alias. The tree view is tailored for each resource, so domains and aliases that you cannot use do not display.
Data type | Drop-down list |
Specifies authentication data, which is a JAAS - J2C authentication data entry, for container-managed signon to the resource.
Select an alias from the list.
If you have defined security domains in the application server, you can click Browse... to select an authentication alias for the resource that you are configuring. Security domains allow you to isolate authentication aliases between servers. The tree view is useful in determining the security domain to which an alias belongs, and the tree view can help you determine the servers that will be able to access each authentication alias. The tree view is tailored for each resource, so domains and aliases that you cannot use do not display.
Data type | Drop-down list |
Specifies the authentication alias for the Java Authentication and Authorization Service (JAAS) mapping configuration that is used by this connection factory.
Click Authentication section, click , and select an alias from the table.
. In theThe DefaultPrincipalMapping JAAS configuration maps the authentication alias to the user ID and password. You can define and use other mapping configurations.
Data type | Drop-down list |
These properties are specific to the data source that corresponds to your selected JDBC provider. They are either required by the data source, or are especially useful for the data source. You can find a complete list of the properties required for all supported JDBC providers in the information center.