Data source collection

Use this page to view configured data sources, which are the resources that provide connections to your relational database.

You can access this administrative console page in one of two ways:
  • Resources > JDBC > Data sources.
  • Resources > JDBC > JDBC providers > JDBC_provider > Data sources.
Version requirement: If you are using the Enterprise JavaBeans (EJB) 1.0 specification and the Java™ Servlet 2.2 specification, you must use the Data sources (V4 - deprecated) console page.

To view or change the parameter values of a data source, click the data source name in the list. On the displayed settings page, you can change existing configuration values and link to additional console pages that assist you in configuring the data source.

To manage a data source, enable the Select check box that corresponds to the data source name in the list and click a button.

Table 1. Button descriptions. Use the buttons to manage data sources.
Button Resulting action
New Opens a wizard that helps you create a data source. Select a scope before clicking New.
Delete Deletes the data source from the product configuration repository.

On single-server installations, deletion occurs after the configuration is saved.
Test connection Attempts to connect to the data source to check the parameters in the data source definition. For the Test connection button to be shown, you must have one of the following roles.
  • Administrator
  • Configurator
  • Monitor, when the com.ibm.ws.console.test_connection_monitor custom property is set to true
For more information, see Testing a connection with the administrative console.
Manage state Opens a J2EE Connector Architecture (JCA) lifecycle management page on the data source. You can pause, resume, or purge the state and control the runtime status of the data source.

Name

Specifies the display name of this data source.

Click a data source name to edit the data source configuration settings.

Information Value
Data type String

JNDI name

Specifies the Java Naming and Directory Interface (JNDI) name for this data source.

Information Value
Data type String

Scope

Specifies the scope of the JDBC provider that encapsulates the driver implementation classes to support this data source. Only applications that are installed within this scope can use this data source.

Provider

Specifies the JDBC provider that encapsulates the appropriate classes.

Description

Specifies a text description of the data source.

Information Value
Data type String