OTN Home > Oracle WebLogic Server 14.1.1.0.0 Documentation > Administration Console Online Help > Create JDBC stores

Administration Console Online Help

Previous Next Open TOC in new window
Content starts here

Create JDBC stores


A JDBC store is a JDBC-accessible database for storing subsystem data, such as persistent JMS messages and durable subscriber information.

  1. If you have not already done so, in the Change Center of the Administration Console, click Lock & Edit (see Use the Change Center).
  2. In the left panel of the Console, expand Services and select Persistent Stores.
  3. On the Summary of Persistent Stores page, click New > Create JDBC Store.

    Note: Once you create a JDBC store, you cannot rename it. Instead, you must delete it and create another one that uses the new name.

  4. On the Create a new JDBC Store page, update the following:
    1. Name -- Enter a name for the JDBC Store.
    2. Prefix Name -- Specify a prefix name to prepend to the table name in this JDBC store for use with multiple instances.
    3. Click Next.

    For more information about these fields, refer to Configuration Options.

  5. On the Select data source page, select a configured JDBC data source or multi-data source used to access the JDBC store. If you need to configure a JDBC data source for the store, click the Configure a Data Source button.

    Note: A JDBC store must use a JDBC data source that uses a non-XA JDBC driver and has Supports Global Transactions disabled. This limitation does not remove the XA capabilities of layered subsystems that use JDBC stores. For example, WebLogic JMS is fully XA-capable regardless of whether it uses a file store or any JDBC store.

    Note: Be sure to select a data source that is accessible to all candidate servers.

  6. Click Next.
  7. On the JMS File Store Targets page, update the following:
    1. Target -- Server instance, dynamic cluster, or migratable target on which to deploy the file store.

      Note: When selecting a dynamic cluster, the store must be targeted to the same dynamic cluster as the JMS server. When selecting a migratable target, the store must share the same migratable target as the migratable JMS server or SAF agent.

    2. Click Finish.

    For more information about these fields, refer to Configuration Options.

  8. On the Summary of Persistent Stores page, select the JDBC store you created in step 2.
  9. On the JDBC Store > Configuration page, update any parameters as required.

    For more information about these fields, refer to Configuration Options.

  10. Click Save.
  11. To activate these changes, in the Change Center of the Administration Console, click Activate Changes.
    Not all changes take effect immediately—some require a restart (see Use the Change Center).

After you finish

You do not need to restart the restart the Administration Server after creating and initially configuring a file store. However, if you modify an existing file store, you must restart the Administration Server.


Back to Top