This patch contains a sample example on how to use data virtualization to integrate data from multiple sources into one report. The virtualized sources appear as a standard JDBC source to the JasperReports library. The only difference is that an SQL query can now refer to tables in multiple databases rather than one. For example, SELECT * FROM Database1.Table1 INNER JOIN Database2.Table2 ON ...
The example uses the included hsqldb test database that is made to appear as two distinct sources. There are no modifications to any other part of the source code base necessary besides the sample code itself.
A patch file as well as the complete set of files used is in the attached zip file.
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now