Forum Discussion

lauravachon's avatar
lauravachon
Contributor
7 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...
nmrao's avatar
nmrao
Champion Level 3
6 years ago
What type of step did use? Is it Jdbc step or groovy? Noticed any errors in log files?
  • lauravachon's avatar
    lauravachon
    Contributor
    6 years ago

    dbSource step.


    I reworked my query and got it to work.

     

    Can you please tell me how to look up the sql logs for a JDBC dataSource step? I am finding it really difficult to debug these steps. Also, I would like to transfer properties into the prepared properties for this type of step and I just am not seeing how to do that.

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

      Community,

       

      Any suggestions?

      lauravachon wrote:

       

       

      Can you please tell me how to look up the sql logs for a JDBC dataSource step? I am finding it really difficult to debug these steps. Also, I would like to transfer properties into the prepared properties for this type of step and I just am not seeing how to do that.

       

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

        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