Forum Discussion

abbas's avatar
abbas
Occasional Contributor
9 years ago

Connection to an Oracle database without CID, but with Servicename

Hi everybody, I cann't configure the connection to Oracle database, because there is no CID. I must configure it just with servicename! Thanks for your support. Abbas
NBorovykh's avatar
NBorovykh
Moderator
9 years ago

Hello Abbas,

 

The connection string templates in R!API are customizable. You can edit them on the "JDBC drivers" tab in preferences.

 

In your case, I guess, you need to replace 

jdbc:oracle:thin:<USER>/<PASSWORD>@<HOST:127.0.0.1>:<PORT:1521>:<SID>

with

jdbc:oracle:thin:<USER>/<PASSWORD>@<HOST:127.0.0.1>:<PORT:1521>/SERVICE

where instead of "SERVICE" you need to provide your real service name (e.g. "orcl").

 

 

  • abbas's avatar
    abbas
    Occasional Contributor
    9 years ago

    Thank you for this message, but I tried it and got the following error:

    Failed to init connection for driver [oracle.jdbc.driver.OracleDriver], connectionString [jdbc:oracle:thin:/@:1521/SHOPTEST]

     

    !!!

    Cheers

    Abbas

     

    • MFagerlind's avatar
      MFagerlind
      Staff
      9 years ago

      The error message seems to indicate that the host name is missing in the connection string. Did you delete it by accident?

       

      Did you use Nathalie's approach or the one I suggested?

       

      Regards,

      Manne

    • nmrao's avatar
      nmrao
      Champion Level 3
      9 years ago
      Oracle Host name is missing in your case.
      • abbas's avatar
        abbas
        Occasional Contributor
        9 years ago

        I used the following configuration:

         Driver: OracleThin/oracle.jdbc.driver.OracleDriver

        Connection String template: jdbc:oracle:thin:<catalog>/<catalog>@<HOST:10.7.1.50>:<PORT:1521>/SHOPTEST

        and I have contact to the named database with SQL Developer, but I get the following error:

         

        " Failed to init connection for driver [oracle.jdbc.driver.OracleDriver], connectionString [jdbc:oracle:thin:/@10.7.1.50:1521/SHOPTEST] "

         

        What I did:

        1-  in config Coection String template like above

        2- Database Configuration -->New

              Driver: OracleThin/oracle.jdbc.driver.OracleDriver

              Host: 10.7.1.50

              Port: 1521

        3: Click Test connection ---> Result: Erorr:

        " Failed to init connection for driver [oracle.jdbc.driver.OracleDriver], connectionString [jdbc:oracle:thin:/@10.7.1.50:1521/SHOPTEST] "

         

         

         

  • dd1984's avatar
    dd1984
    Occasional Contributor
    9 years ago

    Hi,

     

    thank you !!!!! It's working  :)

     

    Your solution is working for me but it's limiting me to test one database only. I have multiple environments and different service name for each data base.

     

    Please suggest how to manage that.

     

    Best regards,

    • JKambli's avatar
      JKambli
      Staff
      9 years ago

      If in a single Environment, if you use 1 database connection then on Databases tab > add 1 connection string.

      http://readyapi.smartbear.com/readyapi/databases/start

       

      Once you do that go to Environments > Add environment > JDBC connection > Edit the connection string for that environment. 

      • dd1984's avatar
        dd1984
        Occasional Contributor
        9 years ago

        Hi,

         

        I tried that but it's over riding the value of connection string i used in Environments with the connection String in JDBC driver.

         

        Here is the set up for oracle.jdbc.driver.OracleDriver 

         

        1.Under preferences used jdbc:oracle:thin:<username>/<pwd>:host:port/servicename   --service name say sampleTest1.se

        2.Created single database entry in Databases jdbc:oracle:thin:<username>/<pwd>:host:port/sampleTest1.se

        3.Create a test environement test  with database where service name is same as i setup in preferences >JDBC driver

        jdbc:oracle:thin:<username>/<pwd>:host:port/sampleTest1.se   --works fine 

        4.Create a test environement test 2 with database where service name is different say sampleTest2.se    --being override with sampleTest1.se

         

        So now service name in database string of  4th from above is being override by the service name i have used in 1st step above.

         

        Please confirm if i missed anything.

         

        Thank you!!