Forum Discussion

lauravachon's avatar
lauravachon
Contributor
6 years ago

oracle jdbc query across a database link

I am having a problem with my sql query that queries data in two different databases via a database link.   e.g. get fdb.this, fdb.that from firstdb fdb join view.sceonddb@dblink sdb on fdb...
Nastya_Khovrina's avatar
Nastya_Khovrina
SmartBear Alumni (Retired)

Hi lauravachon,

 

There are no additional logs for the  JDBC dataSource step. All the available info can be found in the ReadyAPI logs and Error logs. 

 

As for the property transfer, please see this video: https://www.youtube.com/watch?v=03RrPfGOvzw&t=28s

 

lauravachon's avatar
lauravachon
Contributor
6 years ago

Nastya_Khovrina 

 

The video does not help me because the Property associated with the target is greyed out for me with a DB source step. See attached screenshot. I am using version 2.5.0

  • Nastya_Khovrina's avatar
    Nastya_Khovrina
    SmartBear Alumni (Retired)
    6 years ago

    What DataSource do you use? What property of a Datasource should be changed?

    You can use GetData for this. The Property Transfer test step isn't required in this case.

     

    • lauravachon's avatar
      lauravachon
      Contributor
      6 years ago

      It is a JDBC Datasource step. I want to transfer the output of a soap requesst into the prepared properties for the query using the properties transfer.