IBM Support

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

Technote (troubleshooting)


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


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 (I20090926_0409)
    Jazz Foundation - Jazz Team Server, Version (I20090914-1300)
    Rational Jazz Team Server (RQM) - Enterprise

    CRJAZ1363I Loading configuration from " file:conf/jazz/

    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:
    Db Name/Location: "thin:xxxxxxxx/xxxxxxxx@hostname:1521/SDTTST"

    CRJAZ1093I Service class "
    schemagen.PersistentMappingService" failed to activate.

    CRJAZ1141I Failed to get the service "

Resolving the problem

The file specifies that the JDBC connnection to an Oracle sever be in the following format for a non-local host connection:{password}

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:

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

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

Document information

More support for: Rational Quality Manager
Integrations: 3rd Party

Software version: 2.0,

Operating system(s): Windows

Reference #: 1405560

Modified date: 16 March 2011

Translate this page: