Two different database server in one jasper report


In below SQL query I am not able to use DBlink using jasper report

select column_name from user_tab_columns where table_name = 'order' minus select column_name from user_tab_columns where table_name = 'order@DB_test';

where DB_test is a different server.


one server I have connected as below:


priyanka01031983's picture
Joined: Mar 23 2019 - 4:10am
Last seen: 2 months 1 day ago

1 Answer:


iReport is no longer being developed nor supported. Please use Jaspersoft Studio instead.

In Jaspersoft Studio'&s "Dataset and Query Dialog", enter you sql statement and at the bottom tab, select "Data preview" and click on "Refresh Preview Data". If data does not show up, it means Jaspersoft Studio does not support DBlink. In this case, you'll have to write your own program that uses JasperReports library.

hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 2 days 3 hours ago