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.this = sdb.this and fdb.that = scb.that

where fdb.this is not null and fdb.that is not null

 

returns results in my db tool and also in my java code, but returns empty in soapui pro.

 

Any ideas?

  • nmrao's avatar
    nmrao
    Champion Level 3
    What type of step did use? Is it Jdbc step or groovy? Noticed any errors in log files?
    • lauravachon's avatar
      lauravachon
      Contributor

      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)

        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.