Sun Java System Application Server Enterprise Edition 8.1 2005Q2 Administration Guide

Setting Up Database Access

ProcedureTo Set Up Database Access

  1. Install a supported database product.

    For a list of database products supported by the Application Server, see the Release Notes.

  2. Install a JDBC driver for the database product.

  3. Make the driver’s JAR file accessible to the domain’s server instance. See To integrate a JDBC driver.

  4. Create the database.

    Usually, the application provider delivers scripts for creating and populating the database.

  5. Create a connection pool for the database. See To create a JDBC connection pool.

  6. Create a JDBC resource that points to the connection pool. See To create a JDBC resource.

ProcedureTo integrate a JDBC driver

A JDBC driver translates an application’s JDBC calls into the protocol of the database server.

  1. To integrate the JDBC driver into an administrative domain, do either of the following:

    • Make the driver accessible to the common class loader.

      1. Copy the driver’s JAR and ZIP files into the domain-dir/lib directory or copy its class files into the domain-dir/lib/ext directory.

      2. Restart the domain.

    • Make the driver accessible to the system class loader.

      1. In the Admin Console’s tree view (left pane), select Configurations.

      2. Select the desired configuration (for example, default-config).

      3. Select JVM Settings.

      4. On the JVM Settings page, click the Path Settings tab.

      5. In the Classpath Suffix field, enter the fully-qualified path name for the driver’s JAR file.

      6. Click Save.

      7. Restart the server.