Creating a Database Configuration

You can create a new configuration that defines the actual back-end system that the SQL web service uses.

You must have uploaded JDBC driver(s) to use in this configuration. For more information, see Managing JDBC Drivers

  1. In the M3 Web Services Server management page, click the Configurations link. The Manage Configurations page is displayed.
  2. Click the + next to Database Configurations. The Create Database Configuration page is displayed.
  3. Provide information for the following fields and click Save.
    Name

    Provide a name for the configuration.

    Description

    Provide a description for the configuration

    Driver

    Click the + icon. From the drop-down list, select the driver to use in the configuration.

    JDBC URL

    Provide the JDBC URL.

    For SQL Server:

    jdbc:sqlserver://server_name[:port_no][
database_name=database

    For IBM i:

    jdbc:as400://server_name[;prompt=false[;libraries=library1,library2,libraryN]

    For Apache:

    jdbc:derby://server_name:port_no/database_name
    Username

    The user name for the SQL database.

    Password

    The database user password.