WebSphere Application Server V7: Accessing Databases from WebSphere

An IBM Redpaper publication

Note: This is publication is now archived. For reference only.

Published 26 March 2010

cover image

IBM Form #: REDP-4577-01
(46 pages)

More options

Rate and comment

Authors: Carla Sadtler, Leonard Blunt, Saori Tanikawa


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

Others who read this publication also read

Follow IBM Redbooks

Follow IBM Redbooks