cancel
Showing results for 
Search instead for 
Did you mean: 

oracle jdbc query across a database link

Highlighted
Contributor

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?

7 REPLIES 7
Highlighted
Community Hero

Re: oracle jdbc query across a database link

What type of step did use? Is it Jdbc step or groovy? Noticed any errors in log files?


Regards,
Rao.
Highlighted
Contributor

Re: oracle jdbc query across a database link

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.

Highlighted
Community Manager

Re: oracle jdbc query across a database link

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.


 

---------
Tanya Gorbunova
SmartBear Community Manager

Learn SmartBear products in a fun and easy way and prove your knowledge!
>>Participate in the TechCorner Challenge today
Highlighted
Moderator

Re: oracle jdbc query across a database link

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

 



Learn SmartBear products in a fun and easy way and prove your knowledge!
>>Participate in the TechCorner Challenge today
Highlighted
Contributor

Re: oracle jdbc query across a database link

@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

Capture.PNG

Highlighted
Moderator

Re: oracle jdbc query across a database link

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.

 



Learn SmartBear products in a fun and easy way and prove your knowledge!
>>Participate in the TechCorner Challenge today
Highlighted
Contributor

Re: oracle jdbc query across a database link

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.

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors