Create and configure a JDBC provider and data source

 

+

Search Tips   |   Advanced Search

 

 

Procedure

  1. Determine which JDBC provider is appropriate for your data source version, database configuration, and application requirements.

  2. Create a JDBC provider using the administrative console, scripting, or the JMX API

  3. Create a data source using the administrative console, scripting, or the JMX API

  4. Bind the resource reference.

  5. Test the connection (for non-container-managed persistence usage).

  6. When you save the data source configuration, it is saved in a resource.xml file. In most environments, you should not need to modify the jdbc-resource-provider-templates.xml file. However, if updating the file becomes necessary, observe the special considerations that are discussed in J2EE Connector Architecture migration tips.

 

See also


Vendor-specific data sources minimum required settings
Configure a JDBC provider using the administrative console
Configure a data source using the administrative console
Create a data source for a clustered environment
Configure a JDBC provider and data source using the JMX API
Verifying a connection
Test connection service
JDBC providers
Data sources
Looking up data sources with resource references for relational access
Binding to a data source
Configure a JDBC provider using scripting
Configure new data sources using scripting
Configure new WAS40 data sources using scripting
Data source collection
Data sources (V4)
JDBC Provider collection