Skip to main content

WebSphere Application Server V7: Accessing Databases from WebSphere

An IBM Redpaper publication

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

thumbnail 

Published on 26 March 2010

  1. .EPUB (1.0 MB)
  2. .PDF (0.7 MB)

Share this page:   

IBM Form #: REDP-4577-01


Authors: Carla Sadtler, Leonard Blunt and Saori Tanikawa

    menu icon

    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

     

    Others who read this also read