DBC Configuration

If the application utilizes the Grid to provide database connection(s), they will require definition. In the DBC Configuration panel it is possible to manage the JDBC connections. See the installation guide for each application for details.

Column Description
Connection The name of the database connection.
Driver The JDBC driver in use for the database connection.
JDBC URL The connection string for the database connection.
Schema The database connection schema (optional).
Username The database connection user name.

View DBC configuration

  1. Access the Grid Configuration Manager. You can access this page via the grid's Grid Management Pages, which can be accessed through the LifeCycle Manager, Java Web Start, or a web browser.

  2. In the Grid Configuration Manager, click the Applications link. On the next page, click on the name for the application you want to configure.

  3. On the application page, the DBC Configuration section lists the connections used by the application.

Add a JDBC Connection

  1. Access the Grid Configuration Manager. You can access this page via the grid's Grid Management Pages, which can be accessed through the LifeCycle Manager, Java Web Start, or a web browser.

  2. In the Grid Configuration Manager, click the Applications link. On the next page, click on the name for the application you want to configure.

  3. On the application page, click the Add… link in the DBC Configuration section.

  4. In the dialog that opens, enter the name of the connection you want to add in the Connection name text field.

  5. Click the Driver dropdown and select the driver you want to use for this connection configuration. To add, edit or remove drivers, see the Managing database drivers section.

  6. Enter the JDBC URL in the JDBC URL text field. For example, for a JTDS driver connecting to SQL server, you would use the construct: jdbc:jtds:sqlserver://hostname:port/database_name

  7. If you want to use a schema, enter it in the Schema text field.

  8. Enter the database user in the Username text field.

  9. Enter the database user password in the Password text field.

  10. Click the Add button.

  11. Click the Save button at the top of the Application page, then click Save again in the confirmation dialog box.

Edit a JDBC Connection

  1. Access the Grid Configuration Manager. You can access this page via the grid's Grid Management Pages, which can be accessed through the LifeCycle Manager, Java Web Start, or a web browser.

  2. In the Grid Configuration Manager, click the Applications link. On the next page, click on the name for the application you want to configure.

  3. On the application page, the DBC Configuration section lists the connections used by the application. Click the edit button for the connection configuration you want to edit.

  4. To change the driver used by this connection, click the Driver dropdown and select the new driver. To add, edit or remove drivers, see the Managing database drivers section.

  5. To change the JDBC URL, enter the new value in the JDBC URL text field.

  6. To change the schema, enter the new value in the Schema text field.

  7. When you have finished editing, click the Update button.

  8. Click the Save button at the top of the Application page, then click Save again in the confirmation dialog box.

Remove a JDBC Connection

  1. Access the Grid Configuration Manager. You can access this page via the grid's Grid Management Pages, which can be accessed through the LifeCycle Manager, Java Web Start, or a web browser.

  2. In the Grid Configuration Manager, click the Applications link. On the next page, click on the name for the application you want to configure.

  3. On the application page, the DBC Configuration section lists the connections used by the application. Click the remove button for the connection configuration you want to remove.

  4. Click the OK button to confirm that you want to remove the connection configuration.

  5. Click the Save button at the top of the Application page, then click Save again in the confirmation dialog box.

Change the database user for a JDBC connection

  1. Access the Grid Configuration Manager. You can access this page via the grid's Grid Management Pages, which can be accessed through the LifeCycle Manager, Java Web Start, or a web browser.

  2. In the Grid Configuration Manager, click the Applications link. On the next page, click on the name for the application you want to configure.

  3. On the application page, the DBC Configuration section lists the connections used by the application. Click the edit button for the connection configuration you want to update.

  4. In the dialog that opens, write the new username in the Username text field.

  5. Click the Update button.

  6. Click the Save button at the top of the Application page, then click Save again in the confirmation dialog box.

Change the database user password for a JDBC connection

  1. Access the Grid Configuration Manager. You can access this page via the grid's Grid Management Pages, which can be accessed through the LifeCycle Manager, Java Web Start, or a web browser.

  2. In the Grid Configuration Manager, click the Applications link. On the next page, click on the name for the application you want to configure.

  3. On the application page, the DBC Configuration section lists the connections used by the application. Click the edit button for the connection configuration you want to update.

  4. In the dialog that opens, write the new password in the Password text field.

  5. Click the Update button.

  6. Click the Save button at the top of the Application page, then click Save again in the confirmation dialog box.