IBM Rational Quality Manager 2.0 JDBC connection with repotools to Oracle 10g fails due to incorrect syntax

Technote (troubleshooting)


Problem(Abstract)

When trying to connect IBM Rational Quality Manger 2.0 with Oracle 10g installed on a Solaris server using repotools, you might need to test out several syntax options with the JDBC connection

Symptom

If the incorrect syntax is used, the database connection will fail when repotools is run and the Rational Quality Manager repotools log may show:


    Repo Tools
    Rational Quality Manager, Version 2.0.0.1 (I20090926_0409)
    Jazz Foundation - Jazz Team Server, Version 1.0.0.1 (I20090914-1300)
    Rational Jazz Team Server (RQM) - Enterprise

    CRJAZ1363I Loading configuration from " file:conf/jazz/teamserver.oracle
    properties".

    CRJAZ1365I Attempting Initial Database Connection Using
    Db Name/Location: thin:xxxxxxxx/xxxxxxxx@hostname:1521/SDTTST

    CRJAZ0503I Failed to connect to the database: "Listener refused the
    connection with the following error:

    ORA-12514, TNS:listener does not currently know of service requested in
    connect descriptor


    The Connection descriptor used by the client was:
    hostname:1521/SDTTST"
    Db Name/Location: "thin:xxxxxxxx/xxxxxxxx@hostname:1521/SDTTST"

    CRJAZ1093I Service class "com.ibm.team.repository.service.internal.
    schemagen.PersistentMappingService" failed to activate.

    CRJAZ1141I Failed to get the service "com.ibm.team.repository.service.
    internal.rdb.IDatabaseStateService".

Resolving the problem

The teamserver.oracle.properties file specifies that the JDBC connnection to an Oracle sever be in the following format for a non-local host connection:



    com.ibm.team.repository.db.jdbc.location=thin:jazzDBuser/{password}
    @//oracleserver.example.com:1521/ORCL


Depending on the Solaris Oracle configuration, the syntax may need to be changed.

What syntax is used is dependent on the Oracle database administrator. The Oracle documentation which explains how this syntax is used can be found at:

http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/urls.htm#BEIJFHHB

You might need to substitute the / fo a : between the port and database name. As an example the entry in the teamserver.oracle. properties would be:

    com.ibm.team.repository.db.jdbc.location=thin:jazzDBuser/{password}
    @//oracleserver.example.com:1521:ORCL

The password, however, must be encased in curly brackets as {password}.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Rational Quality Manager
Integrations: 3rd Party

Software version:

2.0, 2.0.0.1

Operating system(s):

Windows

Reference #:

1405560

Modified date:

2011-03-16

Translate my page

Machine Translation

Content navigation