Sun Java System Application Server Platform Edition 8.1 2005Q2 Update 2 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.

##### See Also

- JDBC Resources

- JDBC Connection Pools

- How JDBC Resources and Connection Pools Work Together

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

##### See Also

- To Set Up Database Access

- Restarting the Server or Domain

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

- © 2010, Oracle Corporation and/or its affiliates