Use this page to create a data source under a JDBC provider which provides the specific JDBC driver implementation class.
Be sure that you want to use a Version 5.0 data source. If you are using the Enterprise JavaBean component model version 1.0 and Servlets 2.2, you must use a Version 4.0 data source.
To view this administrative console page, click Resources > JDBC Providers > JDBC_provider > Data Sources > data_source.
Configuration tab
Resources such as JDBC Providers, Namespace bindings, or shared libraries can be defined at multiple scopes, with resources defined at more specific scopes overriding duplicates which are defined at more general scopes.
Note that no matter what the scope of a defined resource, the resource's properties only apply at an individual server level. For example, if you define the scope of a data source at the Cell level, all users in that Cell can look up and use that data source, which is unique within that Cell. However, resource property settings are local to each server in the Cell. For example, if you define max connections to 10, then each server in that Cell can have 10 connections.
When resources are created, they are always created into the current scope selected in the panel. To view resources in other scopes, specify a different node or server in the scope selection form.
Data type | String |
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 |
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 dumpnamespace.
Data type | String |
If the checkbox is selected, a CMP Connector Factory that corresponds to this data source is created for the relational resource adapter.
Data type | Checkbox |
Default | Not checked |
Data type | String |
Data type | String |
The WebSphere Application Server data source optimizes
the processing of prepared statements. A prepared statement is a precompiled
SQL statement that is stored in a prepared statement object. This object is
used to efficiently execute the given SQL statement multiple times.
The WebSphere Application Server data source optimizes
the processing of prepared statements and callable statements by
caching those statements that are not being used in an active connection.
Both statement types help maximize the performance of transactions between
your application and datastore.
If the statement cache is not large enough, useful entries are discarded to make room for new entries. To determine the largest value for your cache size to avoid any cache discards, add the number of uniquely prepared statements and callable statements (as determined by the sql string, concurrency, and the scroll type) for each application that uses this data source on a particular server. This value is the maximum number of cacheable statements for a given connection over the life of the server. Setting the cache size to this value means you never have cache discards. In general, the more statements your application has, the larger the cache should be. For example, if the application has 5 SQL statements, set the statement cache size to 5, so that each connection has 5 statements.
Note: This statement cache size setting is different from WebSphere Application Server V4.0.x. In V4.0.x, the maximum number of possible prepared statements is cached for the data source within an application server. In V5.0, statement cache size is defined on a given physical connection.
You can also use the Tivoli Performance Viewer to minimize cache discards. Use a standard workload that represents a typical number of incoming client requests, use a fixed number of iterations, and use a standard set of configuration settings. Note: The higher the statement cache, the more system resources are delayed. Therefore, if you set the number too high, you could lack resources because your system is not able to open that many prepared statements.
In test applications, tuning the statement cache improved throughput by 10-20%. However, because of potential resource limitations, this might not always be possible.
Data type | Integer |
Default | Depends on the database. Most are 10. Informix Version 7.3, 9.2, or 9.3 without latest fix must also be 0. A default of 0 means there is no cache statement. |
This is used by the Relational Resource Adapter at runtime.The default DataStoreHelper implementation class is set based on the JDBC driver implementation class, using the structure: com.ibm.websphere.rsadapter.databaseDataStoreHelper. For example, if the JDBC provider is DB2, then the default DataStoreHelper class is com.ibm.websphere.rsadapter.DB2DataStoreHelper. You can change to your subclass of this DataStoreHelper if necessary.
Data type | String |
Default | Dependent on JDBC driver implentation class |
The Component-managed Authentication Alias is only used when the application resource reference is using res-auth = Application.
If you do not set this field and your database requires the user ID and password to get a connection, then you receive an exception during run time.
If your database (for example, Cloudscape) does not support user ID and password, then do not set the alias in the Component-managed authentication alias or Container-managed authentication alias fields. Otherwise, you see the warning message in the system log to indicate that the user and password are not valid properties. This message is only a warning message, therefore the data source is created successfully.
Data type | Pick-list |
The Container-managed Authentication Alias is only used when the application resource reference is using res-auth = Container.
If you do not set this field and your database requires the user ID and password to get a connection, then you receive an exception during run time.
If your database (for example, Cloudscape) does not support user ID and password, then do not set the alias in the Component-managed authentication alias or Container-managed authentication alias fields. Otherwise, you see the warning message in the system log to indicate that the user and password are not valid properties. This message is only a warning message, therefore the data source is created successfully.
Data type | Pick-list |
The DefaultPrincipalMapping JAAS configuration maps the authentication alias to the userid and password. You may define and use other mapping configurations.
Data type | Pick-list |