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.