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.
- TanyaYatskovska
Alumni
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
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
