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
- Click the Server tab.
- In the Configuration pane, click Database
Connection.
- 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.
- In the JDBC Vendor field, type the
JDBC vendor, such as Derby, DB2®,
Oracle, or SQL. For details, see your database vendor documentation.
- 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}
- In the JDBC Password field, type
the password for JDBC connection, for example, jazzDBpswd.
- 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.
- In the JDBC Connection Pool Size field,
type the number of JDBC connections to keep pooled.
- In the JDBC Connection Pool Wait Time field,
type the maximum time (in milliseconds) to wait for a connection.
- 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.
- Click Save.