Jump to content
  • Add Multiple Data Source Virtualization Sample


    umlawren
    Assigned User teodord
    CategoryBug report
    PriorityNormal
    ReproducibilityN/A
    ResolutionOpen
    SeverityMinor
    StatusNew

    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.


    Attachments: multiplesource.zip

    User Feedback

    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 account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...