When an application or WebSphere® component requires access to a database, that database must be defined to WebSphere as a data source. Two basic definitions are required. First, a JDBC™ provider definition defines an existing database provider, including the type of database access that it provides and the location of the database vendor code that provides the implementation. The second requirement is a data source definition that defines which JDBC provider is to be used, the name and location of the database, and other connection properties. This paper shows how to create these definitions.
This IBM® Redpaper™ publication is the stand-alone version of Chapter 9 of WebSphere Application Server V7 Administration and Configuration Guide, SG24-7615.
Table of contents
Steps in defining access to a database
Example: Connecting to an IBM DB2 database
Example: Connecting to an SQL Server database
Example: Connecting to an Informix Dynamic Server database
Configuring connection pooling properties