Sun Java System Application Server Platform Edition 8.2 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 Application Server.

      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.