Setting Up Database Access

To set up a database access, you must first install the supported database product. For a list of database products supported by the Application Server, see the Release Notes. Then, you must install a JDBC driver for the database product and make the driver's JAR file accessible to the domain's server instance. Next, create the database, the connection pool for the database, and the JDBC resource that points to the connection pool.

After installing the JDBC driver, you must integrate it so that the driver translates an application’s JDBC calls into the protocol of the database server. 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 Administration Console, select the JVM Settings for the desired configuration.

  2. Identify the fully-qualified path name for the driver’s JAR file.

  3. Save the settings and restart the server.