Creating a New Database Configuration

About Creating a New Database Configuration

Occasionally, you may need to access a database that is not currently included in the available database configurations. When this happens, just create a new database configuration using the Database Configurations tab of the CES Admin page.

How To Create a New Database Configuration

This task explains how to create a new database configuration:

  1. Start up the Administration Utility. For more information, refer to Using the Administration Utility. Select the Database Configurations tab.

    The New Database Configuration page appears.

  2. Specify the values in the fields.

    This table describes the fields for database configuration parameters:

    Property

    Description

    Default Value

    DATABASE LABEL

    The label of the database configuration

    Database1

    DB VENDOR

    The name of the database vendor. This property should be chosen
    appropriately. Select Oracle or db2.

    Oracle

    DATABASE NAME

    The name of the database. For example,

    For DB Vendor Oracle, type

    <host>:<port>:<OracleSID>

    For DB Vendor DB2, type

    //host:instanceport/dbname

    host:port:sid

    STARTING CATEGORY

    The category (class) displayed when the browser starts. If you specify the top category, the entire tree APPEARS. If you specify a lower category, only a subset of the tree appears.

    [none]

    APPLICATION

    The ENOVIA V5 VPM/CES solution supported by this configuration.

    [none]

    REFERENCE CURRENCY FOR TRIANGULATION

    Mention the intermediate conversion currency to be used to covert from source currency to target currency.

    [none]

    COMMIT MODE

    After an edit operation is performed, changes can be committed (saved) to the database. CES Java Server has two different commit modes to choose from:

    AUTO: Each user gets a dedicated JDBC connection to the database and data is automatically committed after each database operation.

    MANUAL: Each user gets a dedicated JDBC connection to the database. It is up to the user to manually commit changes to the database.

    AUTO

    CONNECTION MODE

    DEDICATED: Select this mode to use dedicated JDBC connection for every user.

    SHARED: Select this mode to use JDBC Connections from the pool created in Application Server to perform query and edit operations for every user.

    DEDICATED

    ENABLE PERUSER FORM CACHE

    Caches the view information per user if this field is set to true.

    True

    ENABLE LICENSE MONITOR LOGGING

    If enabled, keeps a record of user information for each user who logs into CES Java Server in the License Monitor class under the System Administration folder when Enable License Monitor Logging is set to true.

    False

    NUMBER OF CACHED FORMS

    Enables configuration of the number of XDForm cached in the server. There is a new flag in the dbinfo.cfg file called numberofcached forms with a default value of 100. This allows the server to
    be configured to have a different limit on the number of cached forms it keeps. Values of 1 or any positive integer are treated as their indicated values. Negative numbers or nonnumeric strings are
    converted to an internal flag (-1) that means an infinite number of forms can be cached.

    100

    DISPLAY ORDER

    Modifies the display (sort) order of the database labels in the list box in the CES Java Server Log on page, otherwise the item is automatically added to the bottom of the list.

     

  3. Click Save.

    The values specified are saved in the new database configuration.