Configuring database connections

Edit online

You can configure the database connection for the server in the Administrative web interface.

Procedure

  1. Log in to the Administration page of the Jazz® Team Server or an application registered with the server.
    • For the Jazz Team Server:
      1. Point your web browser to https://[fully qualified hostname]:9443/jts/admin
        Remember: The [fully qualified hostname] is the host name along with the DNS domain reference of the machine on which the Jazz Team Server is installed.
      2. On the Administration page, click the Server tab.
    • For an application registered with the server:
      1. Point your web browser to https://[fully qualified hostname]:9443/[application]/admin to access the application, where [application] is ccm.
  2. In the Configuration pane, click Database Connection.
  3. In the DB Type field, select the type of the connection pool to use. If you select J2EE, the J2EE data source property must be set to use the J2EE database type.
  4. In the JDBC Vendor field, type the JDBC vendor, such as Derby, Db2® , Oracle, or SQL. For details, see your database vendor documentation.
  5. In the JDBC Location field, type the JDBC location as a string. Do not change the {password} text. The password must be set in the JDBC Password field. See the following examples for different databases:
    • Derby
      conf/jts/derby/repositoryDB
    • Db2 
      //localhost:50000/JAZZ:user=db2admin;password={password};
    • Oracle (localhost connection strings must not include preceding //)
      thin:jazzDBuser/{password}@localhost:1521/ORCL
    • ORACLE (non-localhost connection strings must include the preceding //)
      thin:jazzDBuser/{password}@//oracleserver.example.com:1521/ORCL
    • SQL
      //localhost:1433;databaseName=jazz;user=jazzDBuser;password={password}
  6. In the JDBC Password field, type the password for JDBC connection, for example, jazzDBpswd.
  7. In the J2EE Datasource field, type the J2EE data source name. If J2EE is selected in the DB Type field, you must set the J2EE data source property. For example, /j2ee/jazz.
  8. In the JDBC Connection Pool Size field, type the number of JDBC connections to keep pooled.
  9. In the JDBC Connection Pool Wait Time field, type the maximum time (in milliseconds) to wait for a connection.
  10. Set the Skip DB version checking field to True or False. Set this property to True to skip database version checking and use unsupported database versions.
  11. Click Save.