Configuring database connections

If you have administrative rights, you can configure the database connection for the server.

Before you begin

You must be logged on to the administrative Web client and be a member of the JazzAdmins group.
Note: There is a known limitation in using the administrative Web interface to change the database connection for Jazz™ Team Server installed on IBM® i. See Jazz.net for information about configuring the database connection directly in the Jazz Team Server teamserver.properties file.

Procedure

  1. Click the Server tab.
  2. In the Configuration pane, click Database Connection.
  3. In the DB Type field, select the type of the connection pool to use.
    Tip: 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
      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.

Feedback