© Copyright IBM Corp. 2012, 2013. All rights reserved. 351
Chapter 9. Accessing relational databases
from WebSphere
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:
A JDBC provider definition describes a vendor-provided JDBC driver, including the type of
database access that it provides and the location of the files that provide the
implementation.
A data source definition defines which JDBC provider to use, the name and location of the
database, and other connection properties.
In this chapter, we provide information about the various considerations for accessing
databases from WebSphere.
We cover the following topics:
JDBC resources
Steps to define access to a database
Connecting to an IBM DB2 database
Connecting to an Oracle database
Connecting to an SQL Server database
Configuring connection pooling properties
Shared and unshared connections
Troubleshooting database access problems
9
Get WebSphere Application Server V8.5 Administration and Configuration Guide for the Full Profile now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
