WebSphere Application Server V7: Accessing Databases from WebSphere

An IBM Redpaper publication



Abstract

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

JDBC resources
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




Profile

Publish Date
26 March 2010


Rating:
(based on 2 reviews)


Author(s)

IBM Form Number
REDP-4577-01

Number of pages
46