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

- Previous: About JDBC Resources and Connection Pools
- Next: About JDBC Connection Pools

# Setting Up Database Access

- To Set Up Database Access

- To integrate a JDBC driver

## To 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.

## To 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.

- Previous: About JDBC Resources and Connection Pools
- Next: About JDBC Connection Pools

- © 2010, Oracle Corporation and/or its affiliates