Create and configure a JDBC provider and data source
Procedure
- Determine which JDBC provider is appropriate for your data source version, database configuration, and application requirements.
- Create a JDBC provider using the administrative console, scripting, or the JMX API
- Create a data source using the administrative console, scripting, or the JMX API
- Bind the resource reference.
- Test the connection (for non-container-managed persistence usage).
- 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