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...
Forum Discussion
What type of step did use? Is it Jdbc step or groovy? Noticed any errors in log files?
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.
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.
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
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
